0 Replies Latest reply: Jun 15, 2016 1:02 PM by Rehan Saeed RSS

    Year Grouping issue in QlikSense

    Rehan Saeed

      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