topic Compare previous value with current value in QlikView

Compare previous value with current value

Anonymous — Wed, 07 Sep 2011 09:20:58 GMT

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.

Compare previous value with current value

Jason_Michaelides — Wed, 07 Sep 2011 09:32:09 GMT

Does the data source contain the history of changes, or do you need QlikView to keep the history from one relaod to the next?

Compare previous value with current value

Anonymous — Wed, 07 Sep 2011 09:36:13 GMT

Qlikview is keeping the history in QVD files. one file for every day (not the changeday so to speak, but every day).

Compare previous value with current value

its_anandrjs — Wed, 07 Sep 2011 09:39:19 GMT

Hi,

As i understand i think you need to use the smiles in the chart and for these you need to add another column as a smiley for up/down like

For up

'qmem://<bundled>/BuiltIn/arrow_n_g.png'

For Down

'qmem://<bundled>/BuiltIn/arrow_s_r.png'

That is your requirement if so let me know.

Regards

Anand

Compare previous value with current value

lucas4bi — Wed, 07 Sep 2011 09:50:37 GMT

maybe the best solution is working it on the script, first you need to sort the rows by date (order also by product if u have different values for different products or objects):

Tab:

load ...

Product,

Date,

Value

from table order by Product,Date;

Tab2:

load * ,

if(peek(Value)>Value,'Down',

if(peek(Value)<Value,'Up','=')) as ChangeIndicator

resident Tab;

drop table Tab;

in this way you have an indicator for each date looking to the previous value

Compare previous value with current value

its_anandrjs — Wed, 07 Sep 2011 10:03:04 GMT

Hi,

For perticular value how many changes and date records available in the data please provide the details about that, it is only two dates for more changes means there is first change and second change of the records.

Regards

Anand

Re: Compare previous value with current value

SunilChauhan — Wed, 07 Sep 2011 10:11:56 GMT

see the attached filee

hope this help you

Compare previous value with current value

Anonymous — Wed, 07 Sep 2011 10:12:20 GMT

Ok. This looks good.

But in my exampel i have a dimension, and then the first expression picks out the latest value represented and when i added another expression with the "Chageindicator" that dimension can have several. i'v lost it here. completely. but how do i use the changeindicator if you would suggest?

Thanks again!

Re: Compare previous value with current value

its_anandrjs — Wed, 07 Sep 2011 10:40:21 GMT

Hi,

You dont need to load another column for that when you are able to check it with any condition like for Up/Down.

So dont need to load another column it increases unnecesary memory.

See the attached sampl file.

Compare previous value with current value

Anonymous — Wed, 07 Sep 2011 10:41:25 GMT

for som reson i can't download files. think it's the firewall.

Compare previous value with current value

Anonymous — Wed, 07 Sep 2011 11:50:53 GMT

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?