topic Re: Problem with comparison two values in QlikView

Problem with comparison two values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone, I'm trying to colour the cells of a colunm when its value differs from the one in another colunm. Something like this

The expression that rules this in the property of Backgroun Color is:

if([New PVP]<>[Old PVP], RGB(192,192,192), RGB(255,255,255))

But It doesn`t work always as you can see:

Does anybody have a clue?

Thanks in advance.

Re: Problem with comparison two values

sunny_talwar — Mon, 02 May 2016 07:21:08 GMT

What are these columns? New PVP and Old PVP? Just looking at the partial image doesn't really help. Would you be able to give more details, and share a sample if possible?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Problem with comparison two values

Kushal_Chawda — Mon, 02 May 2016 07:29:04 GMT

[New PVP] and [Old PVP] are expression label or field?

try to put the actual expression in background color

if(ExpressionForNewPVP <> ExpressionForOldPVP,RGB(192,192,192), RGB(255,255,255))

Re: Problem with comparison two values

Anonymous — Mon, 02 May 2016 07:29:12 GMT

They are Two prices

New PVP (New Price) is defined bay the following expression:

if(Match(Right(num([PVP Definitivo],'#.##0,00;-#.##0,00'),1),1,2,3,4,5)<>0 , Ceil([PVP Definitivo],0.05),
if(Match(Right(num([PVP Definitivo],'#.##0,00;-#.##0,00'),1),6,7,8,9)<>0, Ceil([PVP Definitivo],0.05,-0.01),
Round(num([PVP Definitivo],'#.##0,00;-#.##0,00'),0.01)))

And Old PVP (Old Price) by this one:

num(PriceToCompare.PVP,'#.##0,00;-#.##0,00')

Thanks for your time

Re: Problem with comparison two values

sunny_talwar — Mon, 02 May 2016 07:32:14 GMT

Why won't the labels work Kush?

Re: Problem with comparison two values

sunny_talwar — Mon, 02 May 2016 07:33:12 GMT

Would it be possible to share a sample? I am still not sure I understand what you are doing.

Re: Problem with comparison two values

Anonymous — Mon, 02 May 2016 07:45:59 GMT

It doesn't work either. [New PVP] and [Old PVP] are expression labels.

Re: Problem with comparison two values

tamilarasu — Mon, 02 May 2016 07:50:36 GMT

Try like below,

if(Round([New PVP] ,0.01)<> Round([Old PVP] ,0.01), RGB(192,192,192), RGB(255,255,255))

Re: Problem with comparison two values

Anonymous — Mon, 02 May 2016 07:55:12 GMT

Yeah!! It works!! I don't know why but it does. Thank you all for your time.

Re: Problem with comparison two values

tamilarasu — Mon, 02 May 2016 08:14:39 GMT

Actually, your both column values are not same, As you have used ceil and round functions in your expression, it gives the illusion. Your [New PVP] column values might be 1.1912 and [Old PVP] can be 1.19. So, We can use round function in the column labels to compare the values.