topic Is This Even Possible? in QlikView

Is This Even Possible?

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

I need a bar chart that displays last year's quarterly sales dollars and I need this year's quarterly sales dollars next to last years. Then I need a line graph on top of this that takes the previous years (quarterly) sales dollars, add 10% to that amount, and display it 1 year in advanced (so Q1 2016 + 10% displayed over Q1 2017) . I would also like for the line graph to "push" 3 months in advanced.

Is this possible?

I have included an image of what I want. This is fake but should help in understanding.

Re: Is This Even Possible?

Anil_Babu_Samineni — Thu, 22 Jun 2017 16:25:14 GMT

You have to calculate like below

Sum({<QuanrterName=>} Sales) + 0.01

=SUM({$<QuarterName={"=$(=fractile($(=Min(QuarterName)),0.1))"}>} Sales)

Re: Is This Even Possible?

dustonmoore — Thu, 22 Jun 2017 16:43:50 GMT

But how do you get Q1 2016 + 0.01 to show on top of Q1 2017??

Re: Is This Even Possible?

Anil_Babu_Samineni — Thu, 22 Jun 2017 16:45:59 GMT

Will you able to share sample application

Re: Is This Even Possible?

dustonmoore — Wed, 26 Jul 2017 15:05:20 GMT

Here it is....

Selected year -1 (or max-1)

Sum({<year= {$(= max(year-1))}>} sale_amount)

Selected Year (or max)

Sum({<year= {$(= max(year))}>} sale_amount)

Previous year + 10%

Sum({<year= {$(= max(year-1))}>} sale_amount)+ Sum({<year= {$(= max(year-1))}>} sale_amount)*.1