topic Create a filter from Expressions in QlikView

Create a filter from Expressions

Wed, 02 Nov 2016 22:34:00 GMT

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

Re: Create a filter from Expressions

robert_mika — Thu, 03 Nov 2016 03:46:21 GMT

Try here:

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

Feeling Qlikngry?

How To /Missing Manual(25 articles)

ww.qliksteps.com

Re: Create a filter from Expressions

Thu, 03 Nov 2016 23:01:35 GMT

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

Re: Create a filter from Expressions

Fri, 04 Nov 2016 00:05:29 GMT

Please ignore my earlier post.

Re: Create a filter from Expressions

Fri, 04 Nov 2016 00:06:13 GMT

Thanks Robert. That worked.

Regards

Indira