topic Bar chart legend to be interactive in QlikView

Bar chart legend to be interactive

Anonymous — Wed, 23 May 2018 09:40:36 GMT

Hi All,

I have a requirement for a bar chart where I am having 3 expressions A,B,C which is a stacked bar graph. When i click on Blue colour legend i.e A the blue bars only should show up , and for other two expressions also the same must be achieved.

I am not sure like how we can achieve this for the expressions. I tried with valuelist but it doesnt work. Any inputs to achieve this would be helpful

Re: Bar chart legend to be interactive

Anonymous — Thu, 24 May 2018 07:41:36 GMT

Hello R Harish

Unfortunately this is not possible.

In the stacked bar chart you can only select dimension values, not the expressions.

You can drill down to the single bar and then to the bar segment, but you can not drill down to an expression.

Best regards,

Marco

Re: Bar chart legend to be interactive

olivierrobin — Thu, 24 May 2018 09:16:35 GMT

hello

you can create a button setting a variable to show/hide value

and use that varaible in a conditional expression to show/hide the expression in your graph

Re: Bar chart legend to be interactive

Anonymous — Thu, 24 May 2018 11:48:04 GMT

Olivier could you pls let me know how do i write the conditional exp

Re: Bar chart legend to be interactive

olivierrobin — Thu, 24 May 2018 11:54:21 GMT

for example, you can code 2 buttons each on setting a variable in a toggle mode

if(var1=0,1,0)

in your graph, for each expression, you check conditional and insert the formula var1=0

so your expression will appear only if tou presse the button

(of course, you have to change var1 by something else for the part of your graph)