topic Re: Set chart to pick current date (today) automatically in QlikView

Set chart to pick current date (today) automatically

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

My data has 4 columns;

Date

Aging Group

Warehouse

B/O Qty.

All 4 columns are updated daily. I have a bar chart which depicts Aging Group.

Instead of selecting date which impacts other data charts. On reloading the document, I want this chart to pick the current date (Today) data automatically to get the below view.

Re: Set chart to pick current date (today) automatically

juraj_misina — Fri, 23 Feb 2018 21:38:15 GMT

Hi,

you can use set analysis for that purpose. Something like:

Sum({<Date={$(=Today())}>} [B/O Qty])

Optionally, you can use on open trigger to make selection for today after opening the app, but I generally do not recommend using triggers.

Hope this helps

Juraj

Re: Set chart to pick current date (today) automatically

Anonymous — Fri, 23 Feb 2018 22:40:42 GMT

Hi Juraj,

The expression seems to be correct but is retaining a blank chart.

Date (Today) is the column header.

Sum({$<[Date (Today)]={$(=Today(),'MM/DD/YY')}>} [B/O Qty])

Regards,

Dev

Re: Set chart to pick current date (today) automatically

juraj_misina — Fri, 23 Feb 2018 22:49:16 GMT

Try

Sum({$<[Date (Today)]={$(=Date(Today(),'MM/DD/YY'))}>} [B/O Qty])

Juraj

Re: Set chart to pick current date (today) automatically

Anonymous — Fri, 02 Mar 2018 10:53:38 GMT

Hello Juraj,

I went with the option of creating a variable which gave me the desired result;

=sum({<Date_Today={'$(vMax_Date_Today)'}>}[B/O Qty])

Thanks for all the help!

Regards,

Dev