topic Re: Pivot Table in QlikView

Pivot Table

upaliwije — Thu, 11 Jun 2015 22:24:20 GMT

Hi Friends

I have created the following Pivot table

Dept	Product	Jan	Feb	Mar	Total
Dept 1	A	1000	2000	1000	4000
	B	3000	4000	2000	9000
	Total	4000	6000	3000	13000
Dept 2	A	2500	2000	1000	5500
	B	3000	6000	2000	11000
	Toal	5500	8000	2000	16500
Dept 2	A	2500	2000	3100	7600
	B	2400	6000	2000	10400
	Total	4900	8000	2000	18000
Total		14400	22000	7000	47500

In the Grant total row I want to obtain grand total for each product A and B

How can I do it pls help

Re: Pivot Table

Anonymous — Fri, 12 Jun 2015 01:31:02 GMT

It may be possible... Can you upload a small sample of your file?

Re: Pivot Table

sunny_talwar — Fri, 12 Jun 2015 01:31:26 GMT

Is this what you want???

If yes, then look at the attached qvw.

Best,

Sunny

Re: Pivot Table

sunny_talwar — Fri, 12 Jun 2015 01:33:46 GMT

It seems I have misunderstood the problem. I am still trying to comprehend the problem.

Re: Pivot Table

Anonymous — Fri, 12 Jun 2015 01:46:35 GMT

See attached

(Sorry sunindia‌ for using your file )

Re: Pivot Table

sunny_talwar — Fri, 12 Jun 2015 02:04:13 GMT

Or may be this also

Re: Pivot Table

upaliwije — Fri, 12 Jun 2015 03:37:22 GMT

Thanks

This is what I want but in your sample document total of both products appear in one row. Pls modify the same to apper in two rows

Re: Pivot Table

sunny_talwar — Fri, 12 Jun 2015 03:43:27 GMT

‌Unfortunately there is no way to have two rows for total and that is why we used the concept of Dimensionality to get you the result you were looking for.

Re: Pivot Table

jagan — Fri, 12 Jun 2015 04:33:12 GMT

Hi,

If you have two products and always displays two products then sunindia solution works fine, what if you have 100 Products? It is not feasible to write this 100 times, instead create a new chart with Product as dimension and use the expression you used in the chart. This is the best solution.

Or you can try Adhoc reporting Adhoc reporting in Qlikview

Regards,

Jagan.