topic Re: comparing values in QlikView

comparing values

Anonymous — Mon, 11 Jan 2016 18:19:40 GMT

I have 2 values 99.900% and the other is 99.7 in the database , I need to compare these two value to color a cell , if first one is greater than 2nd green else red, so when I convert the following number using num as 99.700% or vice versa the color does not change , how do I make both in same format and make sure the color coding works ?

Thanks

Re: comparing values

Gysbert_Wassenaar — Mon, 11 Jan 2016 18:53:35 GMT

Try multiplying the 99.000% with 100 or divide 99.7 by hundred so they are of the same order.

Re: comparing values

Mon, 11 Jan 2016 19:58:44 GMT

You should first convert the text value(99.900%) to a number so that it can be compared to the numeric value (99.7) using the following: num(PurgeChar('96.900%','%'),'#.0');

Do this in the LOAD operation. For example, if the column name is Score:

Load

num(PurgeChar(Score,'%'),'#.0') as Score

Re: comparing values

MarcoWedel — Tue, 12 Jan 2016 00:07:42 GMT

Hi,

this seems to be possible as well:

hope this helps

regards

Marco