topic Show and hide in QlikView

Show and hide

dasaradh — Tue, 08 Sep 2015 11:45:24 GMT

I have combo chart

Dimension: week/year

Exp1 :balance(representing line)

Exp2: interest(which is also line but representing symbols only.)

i want make hide and show interest using button, is it possible?

if it is possible how?

Re: Show and hide

qlikmsg4u — Tue, 08 Sep 2015 11:46:22 GMT

Use button and variable combination.

Check the variable, Button and conditional function of expression

Re: Show and hide

gautik92 — Tue, 08 Sep 2015 11:48:03 GMT

instead make 2 charts one for balance and 1 for interest

create a variable vEnable=1

create a button add external action set variable

vEnable

if(vEnable=1,0,1)

in chart layout tab conditional->vEnable=1

Re: Show and hide

dasaradh — Tue, 08 Sep 2015 11:50:13 GMT

i am using only combo chart not two charts

Re: Show and hide

gautik92 — Tue, 08 Sep 2015 11:52:59 GMT

is it mandatory to have a combo chart?

Re: Show and hide

dasaradh — Tue, 08 Sep 2015 11:55:48 GMT

yes ofcource

Re: Show and hide

gautik92 — Tue, 08 Sep 2015 11:58:02 GMT

then do one thing create another chart which have only balance and overlap it with combo chart and create a button set variable for enabling and disabling

Re: Show and hide

dasaradh — Tue, 08 Sep 2015 12:12:49 GMT

We can do in way

create Variable

vHide and assign value to 0

create a button add external action set variable

vHide

=if(vHide=1,0,1)

chart the exp u want make hide or visible enable conditional

vHide=1