topic Re: Comparing Previous Values in QlikView

Comparing Previous Values

muraliqlik — Sat, 16 Nov 2024 03:54:40 GMT

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.

Thanks

Murali

Shubham_Deshmukh — Wed, 10 Apr 2019 05:46:52 GMT

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

Sue_Macaluso — Mon, 15 Apr 2019 14:52:18 GMT

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