Pivot table

[sat_tok52]

Hi Guru's,

I have two pivot tables and two list boxes ,if I select list  A data it should associate Pivot table A not pivot B,it is similar like alternate states ,but here I don't want use alternate state as per my requirement , I use only condition .

in any help .

Thanks,

Sateesh.T

[ajsjoshua]

Hi

use Dyanamic show and hide

[Chanty4u]

use show hide properties to both tables and list boxes.

[ajsjoshua]

create a variable Vshow

create a list box

if(Vshow=0,'chat1','chart2')

Action:set variable: Vshow

                              if(Vshow=0,1,0)

in chart prop:

layout:conditional  Vshow=0

in other chart:

Vshow=1

Regards,

Joshua.

[sasikanth]

use expression like

for List A,List B

pivot table Expression (list A associated

Sum({<List B=>}Measure)

pivot table Expression (list B associated

Sum({<List A=>}Measure)

[Anonymous]

As per your requirement it seems Alternate State is the best option for you..The reason behind this would be, say if you select any item from List Box A then it should not reflect in Pivot Table B. In this case Alternate states are the best option.

And if it is just a matter of Hide & Show then you can use Set Variable under Action in External Variable

check this?

Hide/show an Object with button set variable

[HirisH_V7]

Hi,

Check this,

else,

QlikView App: Create list boxes that work in an OR mode

HTH,

Hirish