Discussion Board for collaboration related to QlikView App Development.
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?
Please help...
Thanks in advance.
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.
Is that possible to make in straight table ???
Yes. By hiding dimention.
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.
Omg
max(aggr(sum(Qty), Collection, Category,Group, Subgroup))
Swuehl thanks a lot