Discussion board where members can get started with Qlik Sense.
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
Please refer sample application attached herewith.
PFA the sample qvw for reference.