Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a field "Frequency" with the following values
When my QV document opens I want to display text boxes as below:
The color indicators show the latest status.
"Status" has following values:
The challenge is all the frequencies run on different dates for e.g the respective calendar dates for the "Frequency" are as follows
Weekly- 08/05/2015 (Changes Every Friday)
Daily- 11/05/2015 (Changes Daily)
Yearly- 01/01/2015 (next year 01/01/2016)
Monthly - 01/05/2015 (Next month it would be 01/06/2015)
I am trying a workaround, I hope it works. Please help me with the following:
I have a variable vLatestRun which stores the latest corresponding date for the frequencies.
No for the date in vLatestRun I want to check the values in the field "Status" whether it is ended or failed
Hope to understand your req, see doc
Thanks, but for me there is a slight change For the field Status I have 2 values "Ended" and "Failed". For the same date Where vMonthly=01/01/2015 and vYearly=01/01/2015, This logic won't work.