I am new toQ likview so it might be a silly question, but I would really appreciate any help.
I have uploaded 2 tables with exactly the same layout to qlikview (just different dates of computation and Property ID's and I will be uploading more Excel sheets on a weekly basis.
My Data looks like this
|Date Computed||Rationale||Property ID|
|20190215||Okay For EDD||XX4|
|20190221||Okay For EDD||XX4|
I would like to create:
1) Calendar where I could select 2 Dates to compare i.e. 15/02/2019 VS 21/02/2019
2) And a table like below to compare the number of properties that had certain Rationales on Date X with Date Y
So if i select on the calendar: compare 15/02/2019 with 21/02/209 a table should look like this
|Rationale||Number of properties on 15/02/2019||Number of properties on 21/02/2019||Change|
|Okay For EDD||1||1||0%|
Thanks you very much in advance!!
Think that easiest would be to use "Alternate States" on the Dates.
Please check the OL-Help for
1. Create 2 variables vStartDate and vEndDate in setting->Variable overview , give value as your date fields and then create 2 calendar objects and select variable like below, now you are able to select start date and end date,
2. Use below expressions ,
Thanks for the reply
So when i set the variables
This is what caendar looks like and the table isnt populating
Why could this be the case?
Firstly, give limits in Min Max values like, Min value = min(dateField) , Max Value = (max(dateField)
You need to create 2 different calendar objects, you have created one and given both values.
one for start date and one for end Date.
And have you given values to variable in Variable overview ?