Create a filter from Expressions

[#1]

Hi everyone

I have a column chart with three expressions as below:

Amtadvised -- Sum(Amountadv)

Amtequested -- Sum(Amountreq)

Amtapproved -- Sum(Amountapp)

What I would like to do is to create a filter or a list box to display Advised, Requested and Approved as values in the list box so that when the user selects Advised, it just displays Advised column in the chart, or if the users chooses Advised and Requested, then only those tow two columns appear n the chart.

Attached is a screenshot of what I need.

IS this possible to do ?

Regards

Indira

[robert_mika · Accepted solution]

Try here:

QlikView Conditional Enablement of Expressions/ Dimensions AKA Column Selections - YouTube

Feeling Qlikngry?

How To /Missing Manual(25 articles)

ww.qliksteps.com

[#3]

Hi Robert

Thanks for the link.  I was able to create the conditional expressions.  But now the issue is it works for only one selection at a time.  When I select Approved and Advised, an error comes up -- "All Expressions are disabled"

Is there a way to get the selection to work for multiple selections.  The video works for multiple selections.  But I am not able to get it working from me.

Regards

Indira

[#4]

Please ignore my earlier post.

[#5]

Thanks Robert.  That worked.

Regards

Indira