Compare previous value with current value

[Anonymous]

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.

[Jason_Michaelides]

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

[Anonymous]

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

[its_anandrjs]

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

[lucas4bi]

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

[its_anandrjs]

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

[SunilChauhan]

see the attached filee

hope this help you

[Anonymous]

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!

[its_anandrjs]

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.

[Anonymous]

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