Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New 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
Valued Contributor

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