topic How to select which expression to show on chart? in QlikView

How to select which expression to show on chart?

Tue, 20 Sep 2011 21:22:41 GMT

Hi All,

I have a Radar chart, which has 3 Expressions: 'My Institution' ; 'UK Average' ; 'Group1'

What I want to do is perhaps create a listbox, tickbox or something that I can choose to show either of these expressions, all or none.

I tried creating a variable, but not too sure how to show or hide the expressions?

Any ideas or examples would be greatly appreciated on this one.

Thank-you.

How to select which expression to show on chart?

Jason_Michaelides — Tue, 20 Sep 2011 22:39:46 GMT

Hi,

Add an Inline table to your load script as a data island with one field "Expressions" or something. Set the values as the 3 expression names. Then, set the chart expressions to be:

IF(Index(GetFieldSelections(Expressions))>0,yourexpressionhere)

Add a listbox for Expressions and that should do it I think.

Hope this helps,

Jason

Re: How to select which expression to show on chart?

Sokkorn — Wed, 21 Sep 2011 01:16:30 GMT

Hi Beanz,

Check here http://community.qlik.com/message/151099#151099

Regards,

Sokkorn