# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Contributor III

## Set expression by using the count

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)

1 Solution

Accepted Solutions
New Contributor III

## Re: Set expression by using the count

You can try this option:

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

5 Replies
Employee

## Re: Set expression by using the count

Try this

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

New Contributor III

## Re: Set expression by using the count

You can try this option:

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

Contributor III

## Re: Set expression by using the count

Thanks for your great support Joseph,

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

MVP

## Re: Set expression by using the count

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

Contributor III

## Re: Set expression by using the count

Thanks Joseph,

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

Many thanks for your great help.