topic Re: previous? in QlikView

previous?

Anonymous — Tue, 20 Jan 2015 16:15:48 GMT

Hi i have like

table1:

products:

apple

banana

orange

mango

from xlsheet;

when i go like this

load

previous(products) as previousvalues

resident table1;

i am getting data for previousvalues is like

previousvalues:

apple

banana

orange

it is missing mango here why ?

whether previous will not give last record ?

pls tell me ?

Re: previous?

alexandros17 — Tue, 20 Jan 2015 16:25:19 GMT

Previous returns the preceding value of the current row so, according to the load order before banana there is apple, before orange there is banana, before mango there is orange but
for the first record, apple there is nothing before, try with

LOAD products, Previous(products) Resident myTable;
DROP Table myTable;

hope this helps

Re: previous?

Tue, 20 Jan 2015 17:27:39 GMT

Other way round surely? It's the fact that mango is the last record, so can't be a previous value and show in that the field

Re: previous?

MarcoWedel — Tue, 20 Jan 2015 17:34:22 GMT

You are talking about the same thing.

For the product 'apple' there is no previous product, while 'mango' will not be included in the PreviousProduct field.

regards

Marco