Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jekbauita
New Contributor III

Split Subtotals in pivot table

Hello,

    is there any way to split the subtotals by a sub-dimension in a pivot table?

For example:

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
MONTHJANJANFEBFEBTOTALTOTAL
TYPEYEAR201620172016201720162017
CAR102015252545
BIKE14100114
HOUSE258151020

If I select to compute subtotals for the dimension "MONTH", I can only get the total sum of the row (2016+2017), which is meaningless to me. Also, I don't want to switch YEAR and MONTH dimension, because I'd like to do a comparison by months.

I've also attached a .qvw as an example of what I'm trying to achieve.

Any help will be really appreciated.

Tags (3)
1 Solution

Accepted Solutions

Re: Split Subtotals in pivot table

May be use Pick(Match approach....

Capture.PNG

View solution in original post

19 Replies

Re: Split Subtotals in pivot table

May be use Pick(Match approach....

Capture.PNG

View solution in original post

jekbauita
New Contributor III

Re: Split Subtotals in pivot table

Hi Sunny, thanks for your reply, it's really helpful. I think I understood the way it works, does it mind to point me to some resource that can help me with a better understanding of the Pick(Match approach?

Thanks!

Re: Split Subtotals in pivot table

I don't think this approach is documented yet, but there are multiple other examples on the community where I have proposed this way of doing things in bar chart, pivot tables etc... if you want I can share those links?

jekbauita
New Contributor III

Re: Split Subtotals in pivot table

I think it would be great for someone like me wh would like to understand the mechanism behind the scene.

Re: Split Subtotals in pivot table

bhai pehle hi bola tha tuje ki ispe blog likh

Re: Split Subtotals in pivot table

bhai website le li hai...bas blog likhna shuru karna hai.

Re: Split Subtotals in pivot table

kab start karega. people are waiting

Re: Split Subtotals in pivot table

Bahut jald