Pivot table

[Anonymous]

Hi Experts

I have pivot table with 10 calculated expression

For eg.

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.

regards

Ramu

[kaushiknsolanki]

Hi,

I don't think so Expression level Expand and collapse is possible in QlikView.

Regards,

Kaushik Solanki

[robert_mika]

I agree with  kaushiki.

What you can do is conditionally hide your expression:

You can use button with variables

Feeling Qlikngry?

How To /Missing Manual(25 articles)

[Anil_Babu_Samineni]

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

[richard_chilvers]

You could add a button to Show or Hide columns Exp1 - Exp 4:

Can we create a toggle button?

[ToniKautto]

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.

[Anonymous]

Hi Tonic

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.

[robert_mika]

You can add a small text box with the '+' and create a trigger within that box:

Properties--Actions--Add--External-Set Variable...

[richard_chilvers]

Ramu

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.

[ToniKautto]

Th sample is attached in my above comment. Perhaps this link also works...

https://community.qlik.com/servlet/JiveServlet/download/1121546-244912/QC-232278.qvw