Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
Contributor

Re: Set expression by using the count

You can try this option:

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

Best Regards,
Joseph Morales

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)

Highlighted
Contributor

Re: Set expression by using the count

You can try this option:

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

Best Regards,
Joseph Morales

View solution in original post

Highlighted
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

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