Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

rkpatelqlikview
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.

CapturKPI.PNG

I tried with below.But its not working.

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

Thanks in advance!!

1 Solution

Accepted Solutions
joseph_morales
New Contributor III

Re: Set expression by using the count

You can try this option:

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

View solution in original post

5 Replies
Employee
Employee

Re: Set expression by using the count

Try this

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

joseph_morales
New Contributor III

Re: Set expression by using the count

You can try this option:

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

View solution in original post

rkpatelqlikview
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.

Highlighted

Re: Set expression by using the count

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

Capture.PNG

rkpatelqlikview
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.