topic Filter barchart depending on selection on date in QlikView

Filter barchart depending on selection on date

varmekontrol — Sat, 16 Nov 2024 04:00:20 GMT

Can anyone in here help me figure out how to make a bar chart show the last 24 hours, last week (and so on) depending on the date selected?

Right now I am just using

if(created>=today()-1, values)   //For the last 24 hours
if(created>=today()-7, values)   //AGGR daily sum of values

But this is only works for that specific date range.
So if I am to view something that is not within the 24 hour and 7 day selection the bar chart is blank.

What I need, is to write something that is dynamically and adapts to the selected date.

If i choose 01-03-2019. I would like to show the 24 hours of that date in the barchart.
If i choose 01-03-2019. I would like to show the week Monday-Sunday this date is a part of..

//something like

If created day 01-03-2019 is selected (show created>=today()-1)
if created day 01-03-2019 is selected (show Monday-Sunday of created>=today()-7)

Have no idea on how to incorporate my selection in the expression.. ??

Re: Filter barchart depending on selection on date

Vegar — Sun, 31 Mar 2019 05:55:49 GMT

/*sales of previous day*/
sum({<[created]={"$(=date(max([created]-1)))"}>} Amount)

/*sales of selected week*/
sum({<created={">=$(=WeekStart(max(created)))<$(=dayname(WeekEnd(max(created))))"}>} Amount

Re: Filter barchart depending on selection on date

Vegar — Sun, 31 Mar 2019 06:02:24 GMT

If you want to include the current date to previous date value in example above you can do this
sales of previous day and current day*/
=sum({<[created]={"$(=date(max([created]-1)))","$(=date(max([created])))"}>} Amount)