Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
lylererger
Contributor II

Decomposition of data in Pivot Table

Hi Friends.

My task is to show the quantity for the Top Dimention "Collection" as the same quantity for the bottom dimention "Subgroup".


We have four dimentions:


- Collection

- Category

- Group

- Subgroup


And one measure - "sum (qty)" which is returns always 65% for all collections, categories, groups and subgroups:


Untitled.png


When I turn the chart to the group - data is aggregated like on the screenshot below:

Untitled2.png

and so on..

Untitled3.png

and so on..

Untitled4.png

How to show on the collection, category, group layer qty - 65 %? Make some decomposition for all top layer dimentions?

I know that function "Dimentionality()" - helps me to find single dimention, but what expression i need to write there? I need to cheat pivot table and say for all that dimentions result of expression for bottom dimention "subgroup".

Finally i need the result like on screenshot below:

Untitled5.png

Example of qvw in attachment.

Any advices, thoughts, considerations, expressions, solutions?

Please help...

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Decomposition of data in Pivot Table

I think I have neither fully understood your request nor your solution.

What would be the benefit to display a constan value in a pivot table? And if it's not constant across all dimensions, which value do you want to show on top level then?

To do what I think you want, you can create a variable that calculates the sum(Qty) on granular level.

In your pivot chart, you can then expand this variable as a constant value.

See attached.

View solution in original post

4 Replies
Highlighted
lylererger
Contributor II

Re: Decomposition of data in Pivot Table

Is that possible to make in straight table ???

Highlighted
lylererger
Contributor II

Re: Decomposition of data in Pivot Table

Yes. By hiding dimention.

Highlighted
MVP
MVP

Re: Decomposition of data in Pivot Table

I think I have neither fully understood your request nor your solution.

What would be the benefit to display a constan value in a pivot table? And if it's not constant across all dimensions, which value do you want to show on top level then?

To do what I think you want, you can create a variable that calculates the sum(Qty) on granular level.

In your pivot chart, you can then expand this variable as a constant value.

See attached.

View solution in original post

Highlighted
lylererger
Contributor II

Re: Decomposition of data in Pivot Table

Omg

max(aggr(sum(Qty), Collection, Category,Group, Subgroup))

Swuehl thanks a lot