topic Help me in hiding the chart? in QlikView

Help me in hiding the chart?

durgabhavani — Fri, 24 Apr 2015 11:24:30 GMT

Hi All,

I have one text object with one bulb. It has four statuses.

1. no color
2. green
3. red
4. orange

Now by default it has No color --- at this point my barchart needs to be hidden.
suppose if bulb color changed to green or red or orange, Now i need to click on the bulb and then i need to display the hidden chart.

Please help me in writing trigger or in some other way to hide and display the object.

Thanks,
durga

Re: Help me in hiding the chart?

awhitfield — Fri, 24 Apr 2015 11:40:28 GMT

Hi Durga,

1. create a variable e.g v_ShowChart, with a definition of 0

2. on the bulb text object, add an action - External>SetVariable, add the above variable and set the value to =if(v_ShowChart =1,0,1)

3. On the Barchart - Layout - show > add the condition, =v_ShowChart=1

Andy

Re: Help me in hiding the chart?

ankitaag — Fri, 24 Apr 2015 11:57:43 GMT

Hi Durga,

In the Layout tab of Chart properties..

write the conditional expression under show section as

=if(GetFieldSelections(Date)>0,1,0)

Re: Help me in hiding the chart?

durgabhavani — Fri, 24 Apr 2015 12:08:44 GMT

@Andrew

Great! its working!.

it is working based on text object what i expected! Nice!

Suppose if click on clear selections text object in my dashboard it is displaying the barchart in current status.

but i want to hidden bar chart displaying when i click on clear selections. Please Advice!

@ Ankitha

it is working but without clicking on the bulb it is display barchart! but clicking on clear selections barchart is hiding what i am expecting!

Thanks,

Durga

Re: Help me in hiding the chart?

ankitaag — Fri, 24 Apr 2015 12:10:58 GMT

Lol! you want to combine these 2 solutions

Re: Help me in hiding the chart?

awhitfield — Fri, 24 Apr 2015 14:03:31 GMT

Hi Durga,

If you click on the text box a second time, the chart will hide again

Andy

Re: Help me in hiding the chart?

ankitaag — Fri, 24 Apr 2015 14:10:12 GMT

Yes I tried implementing it..

The only problem is when I clear the selections I have to again click the button to hide the chart, it doesnt hide automatically

Re: Help me in hiding the chart?

awhitfield — Fri, 24 Apr 2015 14:22:05 GMT

OK, easy way is to create your own clear selections button that both clears selections and also resets the variable to 0 again.

Andy

Re: Help me in hiding the chart?

ankitaag — Fri, 24 Apr 2015 14:30:24 GMT

hmm..will try that