topic Re: Set Analysis Count If in QlikView

Set Analysis Count If

Zaga_69 — Sat, 16 Nov 2024 04:38:34 GMT

Hi guys,

I want to count the number of profit center with NPM Total Sales NC <=0

I used the following formula, but it does not work:

count({<sum(NPM_TOTAL_SALES)={0}}> PROFIT_CENTER)

Any idea,

Many thanks,

Edi

Re: Set Analysis Count If

sunny_talwar — Mon, 28 Jan 2019 12:23:38 GMT

Try this

Count({<PROFIT_CENTER = {"=Sum(NPM_TOTAL_SALES) <= 0"}>} PROFIT_CENTER)

Re: Set Analysis Count If

Zaga_69 — Mon, 28 Jan 2019 12:33:28 GMT

Hi Sunny

many thanks. It works perfectly. I really appreciate your help.

I used sth like this:

Count(distinct {<PROFIT_CENTER = {"=Sum(NPM_TOTAL_SALES) <= 0"}>} PROFIT_CENTER)

I have still a question. Can you please explain me in a brief manner how this formula works? because I do not understand why you put PROFIT_CENTER twice.

regards,

Edi

Re: Set Analysis Count If

sunny_talwar — Mon, 28 Jan 2019 12:36:01 GMT

So, within the set analysis, the expression is checking if Sum(NPM_TOTAL_SALES) is less than or equal to 0 for a PROFIT_CENTER. If it is, then include it in the calculation... if not then exclude it.

Re: Set Analysis Count If

Zaga_69 — Tue, 19 Feb 2019 08:52:59 GMT

Hi Sunny,

Can you please be kind and explain what you have set up "" into the set analysis and the = which precedes the Sum function.

Best regards,

Edi