0 Replies Latest reply: Feb 29, 2012 9:27 AM by Roberto Postma RSS

    How to show sales of current week and last 4 weeks?

    Roberto Postma

      Hi all!


      I'm pretty new to Qlikview, and puzzled a lot with the current problem:


      I want to show in 1 table

      - in column 1: the sales of the selected week

      - in column 2: the sales of the last for weeks (being selected week, selected week -1, -2, and -3)


      I cannot get column 2 working....


      In my datamodel I have

      - mysequencenumber (a counter...)

      - weeknumber

      - year


      I thought this expression should give me the sales for the week before the week I selected....


      =sum({<mysequence ={      $(=mysequence-1)      } >} sales)


      But the result =0


      Can somebody please advice and/or have a look at my example project where the problem is easily reproducible / visible?


      Any help is very much appreciated!