Expression with pivot table (using previous rows)

Wed, 22 Jun 2011 09:25:43 GMT

Dear community,

I am using Qlikview for a few weeks now, this software is amazingly powerful ! Well... so powerful that I can't find a solution to something really simple I guess...

Let me explain you my problem.

I am loading these datas :

- id sale

- year sale

- month sale

- category sale

- subcategory sale

- turnover sale

I'd like to have a pivot table (see the attached file) with :

- two dimensions : year and category

- two expressions : sum(turnover) and the evolution of the turnover per year per category (sum(turnover from current year) / sum(turnover from previous year) - 1) for each category.

I tried many ways (set analysis and so on), but i couldn't find a solution 😞

Thanks a lot in advance for your time and your answer !

Damien

ps : in the future, i'd like to replace the two dimensions by two hierarchy groups (year/month and category/subcategory)

topic Expression with pivot table (using previous rows) in QlikView

Expression with pivot table (using previous rows)