Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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