topic Re: Pivot table in QlikView

Pivot table

Anonymous — Mon, 12 Sep 2016 07:50:54 GMT

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

Re: Pivot table

kaushiknsolanki — Mon, 12 Sep 2016 07:53:19 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: Pivot table

robert_mika — Mon, 12 Sep 2016 08:03:21 GMT

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)

Re: Pivot table

Anil_Babu_Samineni — Mon, 12 Sep 2016 08:05:15 GMT

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

Re: Pivot table

richard_chilvers — Mon, 12 Sep 2016 08:05:25 GMT

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

Can we create a toggle button?

Re: Pivot table

ToniKautto — Mon, 12 Sep 2016 08:13:04 GMT

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.

Re: Pivot table

Anonymous — Mon, 12 Sep 2016 08:17:23 GMT

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.

Re: Pivot table

robert_mika — Mon, 12 Sep 2016 08:21:03 GMT

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

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

Re: Pivot table

richard_chilvers — Mon, 12 Sep 2016 08:23:54 GMT

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.

Re: Pivot table

ToniKautto — Mon, 12 Sep 2016 08:44:10 GMT

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