topic Re: Dynamic Status display using Text Boxes in QlikView

Dynamic Status display using Text Boxes

shannoypaul — Mon, 11 May 2015 15:32:20 GMT

I have a field "Frequency" with the following values

Weekly

Monthly

Yearly

Daily

When my QV document opens I want to display text boxes as below:

The color indicators show the latest status.

"Status" has following values:

Ended

Failed

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)

Re: Dynamic Status display using Text Boxes

shannoypaul — Mon, 11 May 2015 19:30:41 GMT

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

Re: Dynamic Status display using Text Boxes

maxgro — Mon, 11 May 2015 19:58:37 GMT

Hope to understand your req, see doc

Re: Dynamic Status display using Text Boxes

shannoypaul — Mon, 11 May 2015 21:41:03 GMT

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.