Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Count items that fulfill criteria of 2 different fields.

Hello,

so far I was counting items fulfilling criterias on 1 field.

But now I need to count items fulfilling criterias on 2 fields.

Can any body helps please?

This was counting items of LH, that fulfills the criterias on field Rev.

count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}>}[LH])

Now I need something that makes the same but fulfilling in addition on the field Status the different Statuses {'in review','certified'}

With this I want to exclude all items which have the Rev numbers defined but are with a wrong status "obsolete".

Please I need the formula the soonest possible,

Thanks for the help,

1 Solution

Accepted Solutions

Re: Count items that fulfill criteria of 2 different fields.

May be this

Count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}, Status = {'in review','certified'}>}[LH])

2 Replies

Re: Count items that fulfill criteria of 2 different fields.

May be this

Count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}, Status = {'in review','certified'}>}[LH])

Not applicable

Re: Count items that fulfill criteria of 2 different fields.

Thanks it worked.

Community Browser