Qlik Community

Qlik Sense App Development

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

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