topic Re: Counting based on a condition in QlikView

Counting based on a condition

Zaga_69 — Sat, 16 Nov 2024 04:25:01 GMT

Hi guys!

I would like to count the Cost Center which meets the following condition:

sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC ) /

sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1

I tried sth like this:

if(
(sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC )

sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1 , count({<CostElementFlagPur={1}, PPV_Type=>} distinct CostCenter))

However, it does work, since it counts the total Cost Center and does not take into account the condition mentioned above.

Any Idea?

Many Thanks!

Edi

Re: Counting based on a condition

Gysbert_Wassenaar — Mon, 18 Feb 2019 18:10:48 GMT

Try this:
count({<CostElementFlagPur={1}, PPV_Type=,CostCenter={"=sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC ) / sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1"} >} distinct CostCenter)

Re: Counting based on a condition

sergio0592 — Mon, 18 Feb 2019 18:15:24 GMT

Hi,

Try with :

count({<CostCenter={"=sum({<CostElementFlagPur={1}, Scenario={'ACT'}, PPV_Type= >} Amount_GC ) /

sum({<CostElementFlagPur={1}, Scenario={'PY'}, PPV_Type= >} Amount_GC ))> 1"}>} CostCenter)

Re: Counting based on a condition

Zaga_69 — Mon, 18 Feb 2019 21:21:18 GMT

Hi Gysbert,

Thanks but it does not work. It just give me as result 0

😕

Re: Counting based on a condition

Zaga_69 — Mon, 18 Feb 2019 21:21:51 GMT

Hi Sergio,

Thanks but it does not work. It just give me as result 0

😕

Re: Counting based on a condition

Gysbert_Wassenaar — Tue, 19 Feb 2019 16:41:34 GMT

All the field names must be the exact case sensitive field names. If you then still get 0 then there are no CostCenter values that meet the condition you specified.