Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
lylererger
Creator II
Creator 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
swuehl
MVP
MVP

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
lylererger
Creator II
Creator II

Is that possible to make in straight table ???

lylererger
Creator II
Creator II

Yes. By hiding dimention.

swuehl
MVP
MVP

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

lylererger
Creator II
Creator II

Omg

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

Swuehl thanks a lot