Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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.







Tags (1)
2 Replies

Re: Comparing Previous Values

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

Re: Comparing Previous Values

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

Sue Macaluso