topic Re: Expression in QlikView

Expression

NavinReddy — Wed, 27 Aug 2014 12:45:50 GMT

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

Re: Expression

sujeetsingh — Wed, 27 Aug 2014 12:49:01 GMT

Just check values for the each section seperately

Re: Expression

Anonymous — Wed, 27 Aug 2014 12:54:23 GMT

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

Maybe you need >=-10 and <=0

Re: Expression

NavinReddy — Wed, 27 Aug 2014 12:56:23 GMT

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

Re: Expression

sujeetsingh — Wed, 27 Aug 2014 12:57:26 GMT

That is too a point to think

Re: Expression

NavinReddy — Wed, 27 Aug 2014 12:59:24 GMT

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

Re: Expression

sujeetsingh — Wed, 27 Aug 2014 13:01:12 GMT

can you post a simple sample with 4 or 5 records

Re: Expression

NavinReddy — Wed, 27 Aug 2014 13:01:23 GMT

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

Re: Expression

Anonymous — Wed, 27 Aug 2014 13:07:10 GMT

Niranjan,

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

Re: Expression

NavinReddy — Wed, 27 Aug 2014 13:32:51 GMT

Thank you Michael its working