topic Re: Dynamically selecting dates in the query (in user selection) in QlikView

Dynamically selecting dates in the query (in user selection)

Mon, 16 Mar 2015 05:34:48 GMT

Hi All,

I am quite new to QlikView.Need help to grab the below scenario. I have a date column which giving it as selection to user. User requested to view report as fixed template. To handle that we have inserted few empty with all the values in the table. when user selects the date then it should pic dynamically the default date also. Below is the table:

ColA ColB Colc

aa 100 30-Jun-2014

bb 200 30-Jun-2014

bb 300 01-JUL-2014

aa 0 01-JAN-9999

bb 0 01-JAN-9999

so my query should be select ColA,sum(ColB) where Colc=(userresponse or '01-JAN-999' ). When user selects background it should select the date values 01-JAN-9999 so that all the values would be fixed

Kindly advice.

Re: Dynamically selecting dates in the query (in user selection)

Gysbert_Wassenaar — Mon, 16 Mar 2015 09:02:11 GMT

I think the easiest way is to use a bookmark that contains the fixed date. This bookmark can then be used together with the user selections in a set analysis expression. See attached example.

Re: Dynamically selecting dates in the query (in user selection)

Mon, 16 Mar 2015 09:59:10 GMT

Bro it worked like Gem . Like this can we add any number of Bookmarks is it? If yes can you please give me the Syntax

Thanks in advance

Pavan

Re: Dynamically selecting dates in the query (in user selection)

Gysbert_Wassenaar — Mon, 16 Mar 2015 10:18:12 GMT

Yes, you can add any number of bookmarks: {$+BM1+BM2+...etc}

Re: Dynamically selecting dates in the query (in user selection)

Tue, 17 Mar 2015 06:30:44 GMT

Thank you very much.