topic Pivot Table in QlikView

Pivot Table

Wed, 03 Feb 2010 22:00:17 GMT

I need to create a pivot table as in the attachment. The table has data for Market, Qtr, Week, Amount. I need to calculate %change. %change for Q1 09 will be equal to %over. But for Q2 09, %change will be sum of %over of Q1 and Q2 09 grouped by week. For Q3 09, %change is sum of %Over of Q1, Q2 and Q3 09 and so on.

Can anyone help on this.

Thanks

Pivot Table

disqr_rm — Wed, 03 Feb 2010 23:06:03 GMT

Here you go. Is this what you are looking for?

Rakesh

Pivot Table

Thu, 04 Feb 2010 05:51:01 GMT

Rakesh. It is correct for Q1 qnd Q2 and the result is exactly what I want. But Q3 result is not as expected. It should be Q1 + Q2 + Q3 of %over.

Thanks

Pivot Table

disqr_rm — Thu, 04 Feb 2010 16:52:59 GMT

I am sure this can be done on the chart as well using SET , or rowno() or NoOfRows() functions..... and tricky canculations, but it may be better to generate a separate table and link it via Link Table concept to generate such a chart. I will try some more thangs and let you know if I can come up with anything easier for you. Good luck.

Pivot Table

Thu, 04 Feb 2010 17:35:52 GMT

Thanks. Let me also try.