topic How to diplay Pivot table only when user selects text object in QlikView

How to diplay Pivot table only when user selects text object

Thu, 28 Aug 2014 08:25:28 GMT

Hi Friends,

I want to display my pivot table as popup only when user selects a textobject.

Thanks

Pavan

vardhancse — Thu, 28 Aug 2014 08:27:32 GMT

we can use lay out conditions using some variables

Thu, 28 Aug 2014 08:32:10 GMT

Create a variable ex: "Vshow=1" and use it in the text object-> Actions->External->Setvariable->Give the varaible name "Vshow"and value as 1.

For the Pivot table-> layout->Coditional->Vshow=1.

Follow these steps

Colin-Albert — Thu, 28 Aug 2014 08:32:17 GMT

You can add an Action to the textbox. Use an External Action to set a variable vShowPivot = 1

You can then set the Conditional Show on the Pivot Table to only display the pivot table when vShowPivot = 1

You may also need to add another action to set vShowPivot to 0 to hide the pivot table as well.