Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Above function alternate

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?

4 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi Aamir,

Use Previous().

Regards,

Jagan.

Not applicable
Author

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.

rbecher
MVP
MVP

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

Astrato.io Head of R&D
Anonymous
Not applicable
Author

Hi aammir,

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

Regards

shaik