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: 
NavinReddy
Creator II
Creator II

Expression

Dear Exprerts,

=if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=-10,RGB(153,0,0),RGB(147,193,150))

could some one help me im not getting result whats the error

expression correct,i dont know how to write in between >=-0 and <=-10

some one guide me

Thanks In Advance

Niranjan

1 Solution

Accepted Solutions
Anonymous
Not applicable

Niranjan,

Can you give an example of a number which is >=0 (OK, -0 if you wish), AND <=-10?

View solution in original post

9 Replies
sujeetsingh
Master III
Master III

Just check values for the each section seperately

Anonymous
Not applicable

There is no value which can be >=0 (why -0?) and <=-10

Maybe you need >=-10 and <=0

NavinReddy
Creator II
Creator II
Author

Hi Sujeet,

Thanks you so much i will do that,But Expression its not showing Exact colors

You have any sample expressions

if(sum(values)>=-0 and sum(values)<=-10,RGB(153,0,0),RGB(147,193,150))

like this

Regards,

Niranjan

sujeetsingh
Master III
Master III

That is too a point to think

NavinReddy
Creator II
Creator II
Author

Hi Michael,

I have minus values also in pivot here if its between >=-0 and <=-10

i want to show background Light Red or else Dark Red

any Suggestions please

Regards,

Niranjan

sujeetsingh
Master III
Master III

can you post a simple sample with 4 or 5 records

NavinReddy
Creator II
Creator II
Author

Hi,

if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=10,Green(),

if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=10,RGB(147,193,150),This is working fine

if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-10,RGB(153,0,0),

if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=-10,RGB(153,0,0))))),This one is not working

Regards,

Niranjan

Anonymous
Not applicable

Niranjan,

Can you give an example of a number which is >=0 (OK, -0 if you wish), AND <=-10?

NavinReddy
Creator II
Creator II
Author

Thank you Michael its working