Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
jajati_k_dev
New Contributor II

Set chart to pick current date (today) automatically

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.

ScreenHunter_03 Feb. 24 02.38.jpg

Tags (1)
4 Replies
Highlighted
Luminary
Luminary

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

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

Highlighted
jajati_k_dev
New Contributor II

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

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

Highlighted
Luminary
Luminary

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

Try

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

Juraj

jajati_k_dev
New Contributor II

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

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