topic Re: Above function alternate in QlikView

Above function alternate

Sat, 28 Sep 2013 11:36:40 GMT

Can anyone suggest alternate to above() function that can be used while loading the qvd. I am using it to calculate time between two status and change of status in text.

It works perfectly in pivot table but as there are 1.7 million distinct object_IDs & 10 million + total rows and i need to do analysis on change of status wise, I need to use calculated data on front hand.

Any suggestions?

Re: Above function alternate

jagan — Sat, 28 Sep 2013 12:16:08 GMT

Hi Aamir,

Use Previous().

Regards,

Jagan.

Re: Above function alternate

Sat, 28 Sep 2013 17:22:46 GMT

Well I have already used it but its not working perfectly. Although I have sorted the data correctly. In pivot due to 2 dimensions its working perfectly.

Re: Above function alternate

rbecher — Sat, 28 Sep 2013 19:12:39 GMT

Hi,

you can use peek() in load script. But the data needs to be ordered anyway.

LOAD OBJECT_ID, 
     UDateTime, 
     Status, 
     [Time Taken in minutes], 
     [Status Changed],
     if(OBJECT_ID=peek('OBJECT_ID'),interval(UDateTime - peek('UDateTime'))) as [Time Delta]
FROM

(ooxml, embedded labels, table is Sheet1);

- Ralf

Re: Above function alternate

Anonymous — Sat, 28 Sep 2013 20:32:19 GMT

Hi aammir,

Please find the attachment according to your requirement,please let me know if i did any thing wrong.

Regards

shaik