Conditional Dimension - ignore with Set Analysis

pandabear_de — Sat, 16 Nov 2024 02:32:11 GMT

Hi,

I have hit a little snag, that I can't seem to solve. Using Qlik Sense

I have defined a conditional dimension, so the user can easily filter all rows with defined criteria.

name: has peculiarity
function: =if([PECULIARITIES.DATE]>=$(vWeek1) and [PECULIARITIES.VALUE]>0, 'yes,'no')

In a table showing the underlying data. I would like to ignore the above-mentioned filter 'has peculiarity'. All my attempts have failed.
I have tried he following set analysis in the table

={<[PECULIARITIES.DATE]=,[PECULIARITIES.VALUE]=>}

If I set the filters individually, I can neutralize with set analysis successfully, however I use the above-mentioned conditional dimension, this does not work.

How can I neutralize a filtering of data based on the above-mentioned conditional dimension?

P.S.: I also tried to use Getselectedcount([has peculiarity]) with no luck.

Thanks for your support

Cheers

Jakob

Re: Conditional Dimension - ignore with Set Analysis

tresB — Fri, 01 May 2020 14:58:57 GMT

If it's not typo, try correcting like:

={<[PECULIARITIES.DATE]=,[PECULIARITIES.VALUE]=>} // remove extra angular bracket.

Else I would request a bit more explanation - possibly with a sample app.

Re: Conditional Dimension - ignore with Set Analysis

pandabear_de — Fri, 01 May 2020 16:19:09 GMT

@tresB Thanks, that was a typo in my post. The issue still remains.

topic Re: Conditional Dimension - ignore with Set Analysis in App Development

Conditional Dimension - ignore with Set Analysis

Re: Conditional Dimension - ignore with Set Analysis

Re: Conditional Dimension - ignore with Set Analysis