Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

Not applicable
Author

Thanks it worked.