Set expression by using the count

[rkpatelqlikview]

Dear Experts,

Hope you are doing great.

Please can any one help on below set expression.

Scenario:

There is 2KPI's. If KPI-1 % <=80 and KPI-2% <=80%. Here i want to show the store for review.

Condition for NoReview:  KPI-1 should be <20 and KPI-2>80

Condition for Review:  KPI-1 should be >=20 and KPI-2<=80

Example:

  ->    KPI-1-  28  (Greater than 20) it should be reviewed even KPI-2 greater than 80.

->     KPI-1 - 19 and KPI-2 81, NoReview. Because these two are satisfying the condition.

->      KPI-1 - 10 and KPI-2 - 75 . It should be Review. because KPI-2 less than 80. Even KPI-1 <20.

Here i want to show the count for review in text object.

count is 3. 3 should be in text object.

I tried with below.But its not working.

=count({<KPI1={">20"},KPI2={"<80"}>})>} DISTINCT Store)

Thanks in advance!!

[Lisa_P]

Try this

=count({<KPI1={">20"},KPI2={"<80"}>} DISTINCT Store)

[joseph_morales · Accepted solution]

You can try this option:

Count({<KPI1={">=20"}>+<KPI2={"<=80"}>} DISTINCT Store)

[rkpatelqlikview]

Thanks for your great support Joseph,

But it's showing all the stores, not following the condition.

[sunny_talwar]

joseph.morales‌'s expression seems to be working for me

[rkpatelqlikview]

Thanks Joseph,

Am extremely sorry. It was my script mistake. This is the perfect solution for my query.

Many thanks for your great help.