Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table with Typical information Actual Year -Budget - Last Year. The pivot goes well. But Budget dont have a column in excel, just bring information to account level so for each account qlikview obviously repeat the same total.
So I would like to show only the the subtotal budget when I do clic (Drill Down) on the last level. All value they have to be null...
I put an excel example for better understanding.
Thanks!
Can you try the attached
Would you be able to share the sample application to try it out?
Hi Sunny,
Left a qvw example...
Can you try the attached
Nice Sunny Thanks!
Could You pls explain how did you get this?
Dimensionality() function returns a different number based on the collapsed/expanded dimension. In your case you have three dimensions, when we have all expanded, dimensionality() gives 3
When the DescrFormREM is collapsed, dimensionality() will give 2
and so on...
Using that I told the expression to show Plan when Dimensionality() <= 2