topic Re: Set Expression in QlikView

Set Expression

upaliwije — Mon, 24 Apr 2017 07:00:00 GMT

I have in my QV Doc the following Pivot Table

	Nos	Nos	Nos
MONTH	Jan	Feb	Mar
NET_RANGE1	1	2	3
<=10000	3,048	2,900	3,433
10,001-25,000	3,426	3,186	3,313
25,001-50,000	2,218	1,940	2,389
50,001-500,000	1,723	1,422	2,030
Above 500,001	89	82	78
Total	10,504	9,530	11,243

I want to make Figures in March Column to be red if total of (Jan Feb Mar )/3 is less than Mar Figure. Accordingly I have written the following expression in text colour

=if(match(MONTH,'Mar') and SUM(NOs)>(SUM(NOs)/3), lightRed(),black())

But It does no not work . Pls help me

Re: Set Expression

kamielrajaram — Mon, 24 Apr 2017 11:24:26 GMT

Hi Upali,

Try this

if(SUM({<Month={'Mar'}>} NOs) > (SUM(Total NOs)/3), lightRed(),black())

Regards

Kamiel

Re: Set Expression

upaliwije — Mon, 24 Apr 2017 11:33:06 GMT

Thanks Kamiel

It is not working

Re: Set Expression

Anil_Babu_Samineni — Mon, 24 Apr 2017 11:36:09 GMT

Would you provide sample and expected result for your data set

Re: Set Expression

kamielrajaram — Mon, 24 Apr 2017 11:38:16 GMT

Hi,

would you be able to share a sample?

Regards

Kamiel