Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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.

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.