FAQ Database Discussion Community


append new information in csv files to existing historical qvd

qlikview
Let's say I have a "master" qvd file named salesHistory.qvd, and I want to append new monthly sales from file salesMarch.csv How do I do that without replacing existing information, but adding new months? Thanks for the help!...

Qlikview document reload fails due to authorization restrictions on SharePoint 2010

sharepoint,sharepoint-2010,qlikview
The situation I have created a Qlikview document based on SharePoint 2010 list data. The document is working just fine and I am able to reload data from my desktop, and ready to deploy to our Qlikview server. The problem However, when I run a script ("C:\Program Files (x86)\QlikView\Qv.exe" /r...

Qlikview Substring and charindex equivalent to show values after the - character

qlikview,qliksense
I have a field which has the values field good - examplea good - exampleb bad - examplep ugly - examplet ugly - exampley I want to only show values after the - character. My example output would be field examplea exampleb examplep examplet exampley In SQL it would be...

Qlikview Current selections box to use labels rather than table.fieldnames

qlikview,qliksense
In my Qlik View document I want to change the Current Selections information to use the Label applied to the field rather than the table.field format. For example PartsTable.PartNo Would be Part Number ...

qlikview variable divided by count of a field where monthdatefield is last two months

qlikview,qliksense
Ok so i have a variable eIncorrect and two fields Total and CreatedMonthDate I want to create an expression which is the incorrect amount divided by the count of the total within the last two months. I have tried this (might as well be pseudo): =$(eIncorrect)/Count([Total]) where ([CreatedMonthDate] -2) Which...

Qlikview sorting date dimension formatted as text

sorting,qlikview
Can someone help me sort a date dimension in a QlikView pivot? The dimension is set as follows: Week(DateField) & chr(13) & '' & Weekstart(DateField,0,-1) An example of value: "43 10/19/2014" Another example: "1 12/28/2014" chr(13) returns a new line so that the week number and the day with which...

Qlikview Automate past 12 months selection

date,business-intelligence,qlikview,qliksense
I have a combo chart which shows the average days it took for a person to pay their bill. The Dimension of the Chart is = [Pay Month Year last 12 months] There are no Dimension limits There is 1 expression which is called Average and its definition is: avg({<...

Qlikview line chart with multiple expressions over time period dimension

qlikview
I am new to Qlikview and after several failed attempts I have to ask for some guidance regarding charts in Qlikview. I want to create Line chart which will have: One dimension – time period of one month broke down by days in it One expression – Number of created...

How to select a particular number in a list box and make the other list box to only display the numbers greater than the selected number in QlikView?

business-intelligence,dashboard,qlikview,dashboard-designer,qliksense
I have two list boxes: Box1 and Box2. Box1 has values 10,20,30,40 etc and Box2 has the same 10,20,30 etc. After creating two separate list boxes for Box1 and Box2 respectively in the dashboard, how do I get to show only the values in Box2 which are greater than the...

Load connecting tables from Cassandra in QlikView with DataSatx ODBC

cassandra,datastax,qlikview
I am new to both Cassandra (2.0) and QlikView (11). I have two keyspaces (tables) with large amount of data in Cassandra and I want to load them to QlikView. Since I can not load the entire set, filtering is necessary. // In QlikView's edit script ODBC CONNECT TO [DataStax...

Qlikview reports / chart not generating or printing in colour

business-intelligence,qlikview,qliksense
I have a qlik view report with a colour chart in it which isnt printing in colour, printer is set to colour and also the print preview is in B&W

Qlikview Timestamp formatting upto microseconds?

qlikview
In qlikview I can get timestamp in milliseconds, by setting timestamp format as :- SET TimestampFormat='MM/DD/YYYY hh:mm:ss.fff'; I want to know if there is a way to get time stamp in qlikview upto microseconds....

Load multiple Excel sheets using For loop with QlikView

qlikview
I want to load data from two different Excel files, and use them in the same table in QlikView. I have two files (DIVISION.xls and REGION.xls), and I'm using the following code: let tt = 'DIVISION$' and 'REGION$'; FOR Each db_schema in 'DIVISION.xls','REGION.xls' FOR Each v_db in $(tt) div_reg_table: LOAD...

QlikView : get data filtered in pivot table

pivot-table,qlikview
I found a great tutorial for building a nicer (dynamic) multibox, without extensions. I was able to use it, and I really love it. However, I have an issue: if I use a multibox with a master detail table, then if I filter it from detail then master will automatically...

If a date is 22/12/2015 and has a value of 10, how to fill the value 10 to all the other dates following 22/12/2015 in qlikview?

qlikview,qliksense
I have two tables [ORDERS TABLE] and [PRICE LIST TABLE]. [ORDERS TABLE] contains the fields: OrderDate, ItemCode, Quantity. [PRICE LIST TABLE] contains the fields: Date, ItemCode, Price. Now the [PRICE LIST TABLE] explains the price of certain items during certain dates. It hardly consists of 10 - 15 records. For...

YoY comparison using QlikView

qlikview
My data contains daily data from last March till now. I want to compare the sales amount of 2015/4 vs 2014/4 and 2015/4 vs 2015/3. My date format is 01,02,03,04,...,12 for Date_Month, and 2014,2015 for Date_Year. I first create two variables: vCurrentYear=max(Date_Year) vCurrentMonth=Max (Date_Month) Then I create a bar chart...

QlikView Resources for Beginner Developer

business-intelligence,data-analysis,qlikview,qliksense
I am looking to add Qlikview Development to my skill-set. I have a C# and SQl background. Are there any free online resources to getting me going at developer level not end-user? What's the best starting place for me and the level of difficulty involved. I have seen the capabilities...

Qlikview GetFieldSelections Multiple Selection

qlikview
I have a list box that selects distinct values (one of three) from a listbox. This then filters a chart where I show a bar chart based on sum totals. Currently, it works when one value is selected from the listbox, I require the chart to work with more than...

Using multiple functions in the same field in QlikView

qlikview
I want to use multiple functions on a field and store the result into one field, like this: left(Campagne,len(Campagne)-4) and Replace(Campagne,'%2f','/') and PurgeChar (Campagne,'.g.c') as Campagne; How can I do this?...

Qlik View: Get Values WHERE (value2 = max)

qlikview
i have a relativly simple problem: i have a Dataset that consists of an id(not for entry but for specific object), an age of the object and a power value. So what i get is a lot of entries where there is a power at a specific age for a...

Passing external parameter to QV script

qlikview
I am a newbie to QlikView and looking for some guidance on how to pass external parameter to qv script i.e qvw file. Below is the scenario on which I am working: We are creating a report for which the source is database and we will be using automation tools...

How to display comparisons with set expression?

qlikview
My dataset has WeekEndingDate and Sales. I am displaying a straight table with all the selected data but I need to have another table showing the following: Sales (other columns...) First week : 1,000 Last week : 1,350 Difference : 350 Difference %: 35% My questions: a) Can I have...

Can't open some sheet tabs within a qvw

business-intelligence,qlikview,qliksense
In my QlikView document, when in the web view, i cant open some sheet tabs. Some open fine, others don't seem to have any link on them. These are the main tabs along the top and the properties are the same between one that works and one that doesn't....

Scripting language in qlikvew

scripting,qlikview
As far as I understand, the following is a comment in qlikview //This is a comment 'This is not a comment Whats going on. I see a lot of VB script comments for qlikview on the net like https://denvercoder9.wordpress.com/2012/02/29/qlikview-vb-scripting-for-newbies/ or here http://community.qlik.com/thread/14503 Can some one please enlighten me? I simply...

QlikView ActiveDocument.NoOfSheets not working

scripting,qlikview
I created a new qlikview doc and in the script I just wanted to know the no of sheets. So I wrote iNumSheets = ActiveDocument.NoOfSheets; iVar = 2; FOR t = 0 to iNumSheets iVar = 4; NEXT I get the following error Script line error: FOR t = 0...