Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
apalmtree
Creator II
Creator II

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.

10 Replies
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?

apalmtree
Creator II
Creator II
Author

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
Partner
Partner

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

IamBack
Champion
Champion

see the attached filee

hope this help you

apalmtree
Creator II
Creator II
Author

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.

apalmtree
Creator II
Creator II
Author

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