Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Dimension with qualifying records.

Hi Experts,

Can any one please help me on below requirement.

I have one dimension called STATUS like below.

In this dimension I have to show all the records other than Draft and Failed like status -={'Draft','Failed'}.

Please help me on this.

Thanks in advance.

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: Dimension with qualifying records.

Hi,

try this:

=Aggr(Only({<STATUS-={'Draft','Failed'}.>}STATUS),STATUS)

or

=if(not match(STATUS,'Draft','Failed'), STATUS)

1 Reply
YoussefBelloum
Esteemed Contributor

Re: Dimension with qualifying records.

Hi,

try this:

=Aggr(Only({<STATUS-={'Draft','Failed'}.>}STATUS),STATUS)

or

=if(not match(STATUS,'Draft','Failed'), STATUS)