3 Replies Latest reply: Feb 2, 2011 11:12 AM by Niels Voortman RSS

    Using Set Analysis or not?

      Hi all,

       

      I'm working at my QlikView app for a customer.

      The dataset contains selling data from a petrol store.

      I want to show the amount of liters starting at current week and then 10 weeks backwards.
      I thougt I can make a calculated dimension for this; but after trying and searching it still doesn't work.

      In my selection I select the Year (ex. 2011) and Week (4). At the top of the tab I show the selling data for the selected week.
      In the bottom I want to show the selling history for the last 10 weeks including a compare with last year.

      I've attached an Excel sheet, maybe that makes my question clear.

      Maybe I missed something and is it impossible with Set Analysis?

       

      Gr. Niels