topic Re: chart selection using textbox with variable in QlikView

chart selection using textbox with variable

Thu, 04 Feb 2016 11:59:03 GMT

Hi Experts,

I want to choose the charts dynamically based on the text box selection.

for example, i have two pivot tables

Table1 : Employee details

Table2 : Employee bonus

i want to choose these two based on selected text boxes

text box1 : Employee details created with variable vTab1 in Actions

text box2 : Employee bonus created with variable vTab2 in Actions

& i gave this variables in the Layout -> conditional of corresponding pivot tables

but both the tables appears together as default. not as per the selection.

cant able to find the reason.

Please help to fix this

Anonymous — Thu, 04 Feb 2016 12:06:00 GMT

like this?

settu_periasamy — Thu, 04 Feb 2016 12:24:37 GMT

Maybe try this

Uncheck the "show All sheets and object" in Settings -> Document properties -> Security

Ctrl + Shift + S

MarcoARaymundo — Thu, 04 Feb 2016 12:34:38 GMT

Hi!

You need one variable (Employee details = 1, Employee bonus =2), in the textbox add action Set Variable ->

=If(vShow = 1, 2, 1).