Select a value on the basis of SystemDate

yashcena — Mon, 10 Jul 2017 12:03:49 GMT

I have three columns as shown below:

Each Release Filter has Release Titles and each Release Title has a user-entered SystemDate (not computer's system date) as shown in pivot chart

My requirement is that when the app is opened, then whatever is the date today, the corresponding Release Filter should be selected by default.

For example, when the app is opened on 2017-05-05, PI10 2017.04 should be selected.

when it is opened on 2017-05-15, PI11 2017.08 should be selected by default.

For Release Filter, I have created a trigger to make the selection on document open and I have used the following expression:

=only({<[Release Filter]={"$(=subfield(concat([Release Filter], '|'), '|', 1))"},[System Date]={"$(=vToday)"}>}[Release Filter])

(vToday=Date(Today(),'YYYY-MM-DD')

But no Release Filter is getting selected. Is this expression correct?

When the Release Filter selection is made for today, then I have to show the following things:

These would also follow the same logic i.e. all three values should be shown for the date when app is opened.

For Example, on 2017-05-05, Current Release Title would be May 2017 Major, Release Title Start Date would be 2017-02-04 and Release Title End Date would be 2017-05-05

On 2017-05-15, Current Release Title would be Aug 2017 Major, Release Title Start Date would be 2017-05-06 and Release Title End Date would be 2017-08-04

For Release Title, I have used the following expression:

=only({<[Release Filter]={"$(=subfield(concat([Release Filter], '|'), '|', 1))"},[System Date]={"$(=vToday)"}>}[Release Title])

This expression is working fine. When I make any Release Filter selection, then the corresponding Release Title gets selected (on the basis of SystemDate). But the trigger to select the Release Filter by default is not working.

I can use the same logic to show the start and end dates but first, the selection of Release Filter should be made.

I hope I have made my requirement clear.

Thanks,

YASH

Re: Select a value on the basis of SystemDate

sunny_talwar — Mon, 10 Jul 2017 12:13:58 GMT

May be try this

=Only({<[System Date]={"$(=vToday)"}>}[Release Filter])

Re: Select a value on the basis of SystemDate

yashcena — Mon, 10 Jul 2017 12:31:25 GMT

Thanks Sunny...that worked!

topic Re: Select a value on the basis of SystemDate in QlikView

Select a value on the basis of SystemDate

Re: Select a value on the basis of SystemDate

Re: Select a value on the basis of SystemDate