Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Year Grouping issue in QlikSense

I have a requirement as follows

I have calendar year,  Sale Date and Amount.  I need to create a bar chart  with 3 bars as follows

Bar1  - Max(calendar Year) showing  total amount  where Calendar Year =Sales Year and stacked for each Sales Year

Bar2-  Max(calendar Year) -1 and Max(Calendar Year)-2  where calendar Year -1 = Sales Year -1 and Calendar Year -2 =  Sales Year -2

          Stacked by Sales Year

Bar3-   Max(calendar Year)-3 showing  total amount  where Calendar Year-3 =Sales Year -3 and stacked for each Sales Year


How can I do that in Qliksense

0 Replies