# 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
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:

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

and so on..

and so on..

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:

Example of qvw in attachment.

Any advices, thoughts, considerations, expressions, solutions?

1 Solution

Accepted Solutions
Highlighted
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.

4 Replies
Highlighted
Contributor II

## Re: Decomposition of data in Pivot Table

Is that possible to make in straight table ???

Highlighted
Contributor II

## Re: Decomposition of data in Pivot Table

Yes. By hiding dimention.

Highlighted
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.

Highlighted
Contributor II

## Re: Decomposition of data in Pivot Table

Omg

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

Swuehl thanks a lot