topic Re: All provious data from point of selection in QlikView

All provious data from point of selection

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

Hi Experts,

I have a chart say with expression sum(sales). When user selects on Month say Dec, the chart should not just show the datfor december, but also all the previous months(and previous years) starting from the selected month, in this case December.

I want to show this in a straight table and also in text object with just total figure.

Please guide me to proper resources or any apps that can help me.

Thanks!

Re: All provious data from point of selection

adamdavi3s — Tue, 24 Jan 2017 12:42:44 GMT

Maybe add in a period then just use set analysis for <= period while ensuring you exclude any date parameters in the set

e.g. december 2016 = 201612

March 2014 = 201403

So your set can be something like sum({<Year-=,Month-=,Period={"<=Period"}>} sales)

Of course you could always do this with date, so generate the date for the end of December or something

Re: All provious data from point of selection

sunny_talwar — Tue, 24 Jan 2017 12:49:33 GMT

Wouldn't it be better to use Max(Period) so that you can still see a result when no selection has been made?

Re: All provious data from point of selection

adamdavi3s — Tue, 24 Jan 2017 12:55:46 GMT

agreed, hasty answer!

Re: All provious data from point of selection

surajap123 — Tue, 24 Jan 2017 14:25:20 GMT

Thanks

Re: All provious data from point of selection

sunny_talwar — Tue, 24 Jan 2017 14:43:31 GMT

Please mark Adam's answer as correct or helpful as he is the one you came up with a solution to your post. All I suggested was a small change my friend.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny