Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compare previous value with current value

Hi,

I want to compare values based on previos time the value was changed.

So say i have a value: 3,0 that change 2011-09-01 and then that value changed 2011-09-07 to 4,0.

now, in my chart, i want to compare these values to show with arrows the change (up or down).

How do i find these values when the dates aren't frequent?

I'm thinking i might have to do something in the script or am i wrong?

Thanks in advance.

A.

Labels (1)
10 Replies
Anonymous
Not applicable
Author

There´s several dates for change in my data. does the peek thing still works if so?

I've tried it on a sample of data but it gives me two rows with the latest value one of those rows has a = as changeindicator and the other one has a Down (which is the correct one).

Is this becaus i have 3 different change dates?