topic Re: Expression legend filtering issue in QlikView

Expression legend filtering issue

Fri, 30 Aug 2013 06:00:41 GMT

Hi everyone ,

In my chart I have one dimension and against it there are 2 expressions which are stacked over one another , when I click on legend of first expression then what I want is to show only that expression bar in chart and hide other one(as we have legends functionality when we have 2 dimensions and 1 expression), Is there any workaround to do this???

Regards:

Mubbasher

Re: Expression legend filtering issue

vikasmahajan — Fri, 30 Aug 2013 06:36:53 GMT

Select Second Dimension -> Untick -> Show Legend Option

hope this is resolve.

Vikas

Re: Expression legend filtering issue

michael_maeuser — Fri, 30 Aug 2013 06:41:08 GMT

for each expression you can add a condition:

e.g. your 2 expressions:

sum(a)

sum(b)

condition for expression a:

getselectedcount(b)=0

condition for expression b:

getselectedcount(a)=0

Re: Expression legend filtering issue

Fri, 30 Aug 2013 06:51:37 GMT

Hi Michael ,

My two expresssion are

Sum(Cost)

Avg(Cost)

this chart have only 1 dimension i.e. Product

there are two legends

Red=Sum(Cost)

Green=Avg(cost)

So what I want when i click over Red legend in chart it should only show Red Bar and in legends only red legend.

Re: Expression legend filtering issue

rajeshvaswani77 — Fri, 30 Aug 2013 06:52:13 GMT

Would Dimension that is a drill down group in your case help?

Looks like thats what you are looking for.

thanks,

Rajesh Vaswani

Re: Expression legend filtering issue

Fri, 30 Aug 2013 07:00:15 GMT

No I only have one dimension so no need of a group dimension.

Re: Expression legend filtering issue

tresB — Fri, 30 Aug 2013 07:02:54 GMT

You can groug the expressions too in expression tab.

Re: Expression legend filtering issue

Fri, 30 Aug 2013 07:28:17 GMT

I know but in my case user should be able to view both expressions at the same time , in case if he want to view any of one then he can click over its legend to view only that expression.

Re: Expression legend filtering issue

tresB — Fri, 30 Aug 2013 07:50:09 GMT

No direct option I can suggest you. Workaround could be like: try with three buttons(Both, Expr1, Expr2) and conditional enablement of the expressions. Could that be an option?

Re: Expression legend filtering issue

Fri, 30 Aug 2013 08:10:17 GMT

That can be an option , but as in another chart I have 10 expressions , for those there will be hiding legend and positioning legends will be a problem.