Discussion Board for collaboration related to QlikView App Development.
I have pivot table with 10 calculated expression
Dim 1 Exp1, Exp2, Exp3, Exp4 Exp5 Exp6, Exp7, Exp8,Exp9, Exp10
i have to resign pivot that as below. when i click the '+' symbol and it expands and show previous four expression. Please note that these are all calculated expression .it show something like grouping in Excel.
Dim 1 Exp5 Exp10
Please help me to how to achieve it.
I don't think so Expression level Expand and collapse is possible in QlikView.
I agree with kaushiki.
What you can do is conditionally hide your expression:
You can use button with variables
I didn't get your intention. Would you be able to provide excel (Which you mention like excel) - So that we can try to solve your issue
You could add a button to Show or Hide columns Exp1 - Exp 4:
From the example I can not see why you would need to use a pivot table. The setup looks very much like a straight table.
The only way to do something similar is to apply conditional show on the expressions, and then trigger the condition through a triggered action. See attachment for example.
I could not find the attachement. Please send it again
Is it possible to add button in column expression. "+" (button) Expression name so when i click the button it would expand.
You can add a small text box with the '+' and create a trigger within that box:
Try again to load Toni's example QVW. It shows what can be done with a button. Then you can consider how best to make the design you're looking for in your model.
Th sample is attached in my above comment. Perhaps this link also works...