Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
suresh_ssl
New Contributor

Need Last before Records in an intermediate Table.

Hi Team,

I have an Requirement,

I need to Compare Part wise Latest price and Previous Purchase prices.

so that i need latest records into one intermediate table & previous records into another intermediate table and Finally those 2 Merge into one table, so that its very easy to compare.

Am struggling to get data into intermediate tables can any suggest me approach how to get, if is there any better solution pls suggest me on same

Thanks&Regards

suresh

2 Replies
rahulpawarb
Valued Contributor III

Re: Need Last before Records in an intermediate Table.

Hello Suresh,

Please refer sample application attached herewith.

Regards!

Rahul

karunpreet
Contributor II

Re: Need Last before Records in an intermediate Table.

Hi Suresh,

PFA the sample qvw for reference.

Regards

KP