topic Re: KPI Required on Dimension with Condition and Expression in Straight Table in QlikView

KPI Required on Dimension with Condition and Expression in Straight Table

pradeep92 — Thu, 21 Mar 2019 12:37:37 GMT

hello,

I have a requirement where we have a straight table with Products. Those products are colored based on a condition.

Color Condition:

=if(sum({<Panier={'base'},ANNEE_CALENDER={'$(v_CY)'}, SOURCE={'MENSUEL'}>} CA)<>0,rgb(0,200,0),

if(sum({<Panier={'base'},SOURCE={'DIFF'}>} CA)>0 ,RGB(0,0,200),rgb(200,0,0)))

Now we also have the expression to count the no of Products.

No of Products Condition:

=Count({1<Panier={'base'}>} DIMART_PRIO)

Now we want the total number of Products based on the color coding of the products

O/P: So we want the of the count of Products in Text object. Green Red and Blue can be created nearby.

Green - 4

Red - 3

Blue -3 ... PFA

Re: KPI Required on Dimension with Condition and Expression in Straight Table

sunny_talwar — Thu, 21 Mar 2019 12:47:39 GMT

May be this

Green

Count(DISTINCT {<Product = {"=Sum({<Panier = {'base'}, ANNEE_CALENDER = {'$(v_CY)'}, SOURCE = {'MENSUEL'}>} CA)<>0"}>} Product)

Blue

Count(DISTINCT {<Product = {"=Sum({<Panier = {'base'}, SOURCE = {'DIFF'}>} CA) > 0"}>} Product)

Red

Count(DISTINCT Product) -
Count(DISTINCT {<Product = {"=Sum({<Panier = {'base'}, ANNEE_CALENDER = {'$(v_CY)'}, SOURCE = {'MENSUEL'}>} CA)<>0 or Sum({<Panier = {'base'}, SOURCE = {'DIFF'}>} CA) > 0"}>} Product)

Re: KPI Required on Dimension with Condition and Expression in Straight Table

pradeep92 — Fri, 22 Mar 2019 07:13:37 GMT

Hello Sunny,

This is working fine as expected. thank you very much