topic Re: Set expression by using the count in QlikView

Set expression by using the count

rkpatelqlikview — Thu, 05 Jul 2018 02:28:54 GMT

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 — Thu, 05 Jul 2018 03:09:57 GMT

Try this

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

joseph_morales — Thu, 05 Jul 2018 05:33:42 GMT

You can try this option:

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

rkpatelqlikview — Fri, 06 Jul 2018 04:23:28 GMT

Thanks for your great support Joseph,

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

sunny_talwar — Fri, 06 Jul 2018 13:23:16 GMT

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

rkpatelqlikview — Thu, 12 Jul 2018 15:00:07 GMT

Thanks Joseph,

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

Many thanks for your great help.