Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Set Expression

I have in my QV Doc the following Pivot Table

NosNosNos
MONTHJanFebMar
NET_RANGE1123
<=100003,0482,9003,433
10,001-25,0003,4263,1863,313
25,001-50,0002,2181,9402,389
50,001-500,0001,7231,4222,030
Above 500,001898278
Total10,5049,53011,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

4 Replies
kamielrajaram
Creator III
Creator III

Hi Upali,

Try this

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

Regards

Kamiel

upaliwije
Creator II
Creator II
Author

Thanks Kamiel

It is not working

Anil_Babu_Samineni

Would you provide sample and expected result for your data set

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kamielrajaram
Creator III
Creator III

Hi,

would you be able to share a sample?

Regards

Kamiel