topic Re: How can I compare latest Table Values? in QlikView

How can I compare latest Table Values?

Tue, 27 Jan 2015 06:19:01 GMT

Good day,

I have a problem. can someone help me please

I would like to compare the latest value in a table

Latest value of A and Latest value of B

for this example

Latest data value of A and B is last 2015/1/20 and I want to compare the two values

if A>B then the color is red while if A < B then the color is green.

I am created to variable and get the peek of every column but it doesn't work

Let UA7A = Peek('A',-1,'Tbl_UA7');

Let UA7B = Peek('B',-1,'Tbl_UA7');

but no UA7A & UA7B Variables created

Please Help me

Thank you very much

Anonymous — Tue, 27 Jan 2015 06:43:11 GMT

Hello,

those variables should be created. I tried it and it worked. Check once.

I used

let y= peek('start_date',-1,'x');

Tue, 27 Jan 2015 06:54:32 GMT

Thank you for this Ravichandra Nadminti

I think my QlikView has a problem

Thank you very much