topic Re: Pivot table in QlikView

Pivot table

sat_tok52 — Wed, 17 Feb 2016 04:42:21 GMT

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

Re: Pivot table

ajsjoshua — Wed, 17 Feb 2016 04:43:55 GMT

use Dyanamic show and hide

Re: Pivot table

Chanty4u — Wed, 17 Feb 2016 04:46:01 GMT

use show hide properties to both tables and list boxes.

Re: Pivot table

ajsjoshua — Wed, 17 Feb 2016 04:47:04 GMT

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.

Re: Pivot table

sasikanth — Wed, 17 Feb 2016 05:24:30 GMT

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)

Re: Pivot table

Anonymous — Wed, 17 Feb 2016 05:45:21 GMT

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

Re: Pivot table

HirisH_V7 — Wed, 17 Feb 2016 06:59:59 GMT

Hi,

Check this,

else,

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

HTH,

Hirish