Year Grouping issue in QlikSense

Wed, 15 Jun 2016 17:02:03 GMT

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

topic Year Grouping issue in QlikSense in App Development