Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dustonmoore
Contributor II
Contributor II

Is This Even Possible?

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.

1 Solution

Accepted Solutions
dustonmoore
Contributor II
Contributor II
Author

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

View solution in original post

4 Replies
Anil_Babu_Samineni

You have to calculate like below

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

Or

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
dustonmoore
Contributor II
Contributor II
Author

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

Anil_Babu_Samineni

Will you able to share sample application

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
dustonmoore
Contributor II
Contributor II
Author

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