7 Replies Latest reply: Jan 4, 2015 6:32 AM by Ferdinand Rinaldy RSS

    How to create comparison sales current and last year with restriction?

      Hi all,

       

      i'm still learning Qlik and i got this issue to handle, bottom line is i have to create top gain & loss sales with min value (like above 100 mio on top gain and 50 mio on top loss, so the data will shown up above 100 & 50 mio only)

       

      So the detail is, i have to compare between CY and LY which one is the best sales on CY above 100 mio sales for Top Gain and for Top Loss,  compare between CY and LY which one is the most poor sales on LY  but show data above 50 mio sales, i've been try using Aggr function and choose dimension limit for restriction but its not shown up properly, Anyone ever face this issue before?

       

      Thanks a lot before,

       

      Cheers,