Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Comparing Previous Values

Hi Team,

Below is the sample data of my application.

ID , Type, Version

xxxa, Policy, 1

xxxa, Policy , 2

xxxa, Document , 3

xxxa, Document, 4

xxxb, Policy,1

xxxb, policy,2

xxxc, Policy, 1

xxxc, Document, 2

I  have to show the records whose type has changed along with the other metadata 

My Desired Result should be as per below

ID, Type, Version

xxxa, Document, 3

xxxc, Document, 2


Could you please help me in achieving this.







Labels (3)
2 Replies

Can you pls elaborate your condition because I am not getting exact change in your data as per your requirement.
Community Manager
Community Manager

@muraliqlik Is this for QlikView or Sense? Id like to move it into the correct product forum. 

Sue Macaluso