topic Re: Use toggle select to select value from a calculated expression in QlikView

Use toggle select to select value from a calculated expression

Anonymous — Wed, 06 Jan 2016 21:34:10 GMT

Hi everyone,

I have a column in a chart which is calculated using an if() function. This column is called "Need PA" and all values in this column are 1 or 0.

I would like to select all values of 1 from this column using a toggle select using an action button.

Is this possible?

Here is how everything is currently set up, but nothing happens when I click the button.

Thanks in advance.

Michael

Re: Use toggle select to select value from a calculated expression

sunny_talwar — Wed, 06 Jan 2016 21:41:53 GMT

Need PA is a expression, you won't be able to use it the way you are trying here. Do you have a sample you can share to see how the data is like and how can this be done for your data?

Re: Use toggle select to select value from a calculated expression

maxgro — Wed, 06 Jan 2016 21:45:19 GMT

maybe Toggle Select

Field PO Number

Search String RODLB1

because Need PA with 1 are the PO Number with RODLB1

Re: Use toggle select to select value from a calculated expression

sunny_talwar — Wed, 06 Jan 2016 21:48:06 GMT

Ha!!! that is true

Re: Use toggle select to select value from a calculated expression

Anonymous — Wed, 13 Jan 2016 18:51:34 GMT

Thanks for the info, but not being able to select from an expression was kind of a deal breaker.

I ended having to restructure a few of the data fetches.

Thanks again.