topic Re: [ASK] how to sum last 50 days grouped by dayname in QlikView

[ASK] how to sum last 50 days grouped by dayname

rendiyan — Wed, 25 Oct 2017 12:52:06 GMT

Dear QlikView master,

my client have a requirement to sum value for the last 50days and grouped by dayname.

For example mw last 56days data will be like below :

with expressions :

sum({<Year=, Quarter=, Month=, Week=, CalDate=

{'>=$(=date(daystart(vEndDate, -$(vDayParam)*7)))'}*{'<=$(=date(daystart(vEndDate)))'}>}

Quantity)

And User expectation will be like :

Is that achieveable with qlikview?

if yes, how to achieve that expectation?

Thank You,

Best Regards

Re: [ASK] how to sum last 50 days grouped by dayname

felipedl — Wed, 25 Oct 2017 13:05:05 GMT

Hi Rendi,

Use the following expression,

sum({<Date={">=$(=Date(Today()-50,'MM/DD/YYYY'))"}>}aggr(sum({<Date={">=$(=Date(Today()-50,'MM/DD/YYYY'))"}>}Value),NameDay))

And make a chart with only the NameDay and expression. I've hardcoded the 50 value, so it gets the last 50 days as of today, but you can change the logic behind it

Attached a sample data and qvw file.

Felipe.

Re: [ASK] how to sum last 50 days grouped by dayname

Anonymous — Wed, 25 Oct 2017 15:42:37 GMT

Not sure why you would need the aggr.

I think just this would work.

sum({<Date={">=$(=Date(Today()-56,'MM/DD/YYYY'))"}>}Value)

Re: [ASK] how to sum last 50 days grouped by dayname

felipedl — Wed, 25 Oct 2017 16:18:56 GMT

Yeah, you're right Wallo, it's not really needed.

He can simply put it the way you stated.

Re: [ASK] how to sum last 50 days grouped by dayname

rendiyan — Thu, 26 Oct 2017 04:17:57 GMT

yes thank's..