topic Re: Set analysis in QlikView

Set analysis

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

Hi guys,

Just a simple question. I am trying to set the text color expression in a pivot table by doing:

IF(NPM_TOTAL_SALES<= 0,'red','green')

However, it does not work. The negative number are still in green.

Any idea?

Many Thanks,

Edi

anushree1 — Mon, 28 Jan 2019 10:23:45 GMT

Use it like : IF(NPM_TOTAL_SALES<= 0,red(),green()) or IF(NPM_TOTAL_SALES<= 0,rgb(255,0,0),rgb(0,255,0))

MindaugasBacius — Mon, 28 Jan 2019 10:24:11 GMT

IF(NPM_TOTAL_SALES<= 0,red(),green())

Use the above.

Besides why not trying.

Keep in mind the below option works only with expressions:

juliensaintmaxent3113 — Mon, 28 Jan 2019 10:42:30 GMT

hi,

try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')

Bye

Zaga_69 — Mon, 28 Jan 2019 10:44:57 GMT

Thanks. However it does not work.

juliensaintmaxent3113 — Mon, 28 Jan 2019 10:46:24 GMT

can you send us screenshot of your graphice and expression please?

juliensaintmaxent3113 — Mon, 28 Jan 2019 10:49:57 GMT

try to add expression with if(NPM_TOTAL_SALES<= 0,'KO','OK') in the graphic and look if it works fine.

Zaga_69 — Mon, 28 Jan 2019 11:35:12 GMT

Thanks!

Now it works 🙂