topic Re: How to compare the same field values which differs but it has common primary key ? in QlikView

How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Thu, 25 Feb 2016 06:09:56 GMT

Suppose if I have,

primary_key Name some_value

101 XXX A23

102 YYY S56

103 ZZZ T74

101 XXX R88

Now I need to update the changed value in the design part along with the old value in a pivot table. How to do so?

Re: How to compare the same field values which differs but it has common primary key ?

sunny_talwar — Thu, 25 Feb 2016 09:45:06 GMT

So what is your desired output for the sample you have provided above?

Re: How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Thu, 25 Feb 2016 09:48:10 GMT

that is i want to display the changed value.... for example in a pivot table old value is A23 and the new value is R88 but i couldnt do so using if condition. But the data resides in a single table

Re: How to compare the same field values which differs but it has common primary key ?

sunny_talwar — Thu, 25 Feb 2016 10:53:23 GMT

Are you trying to do this on the front end of the application?

Re: How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Thu, 25 Feb 2016 10:54:45 GMT

ya front end

Re: How to compare the same field values which differs but it has common primary key ?

sunny_talwar — Thu, 25 Feb 2016 11:18:17 GMT

Assuming you have a date field which determines which some_value is most recent you can try this kind of expression:

FirstSortedValue(DISTINCT some_value, -datefield)

Re: How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Thu, 25 Feb 2016 11:19:38 GMT

no there is no datefield so how to proceed ?

Re: How to compare the same field values which differs but it has common primary key ?

sunny_talwar — Thu, 25 Feb 2016 11:32:14 GMT

How do you intend to determine which one is recent and which one is old?

Re: How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Thu, 25 Feb 2016 11:34:44 GMT

I mean the some_value to be some grade value for example initially he may in grade 0 that is G0 and later on to G1 but there is no record of when he has been changed. but i am forced to display the change in grade level with the respective person i.e, i need to display only the people whose grade level has been changed.

Re: How to compare the same field values which differs but it has common primary key ?

sunny_talwar — Thu, 25 Feb 2016 12:54:08 GMT

If it is always going to be increasing may be use MaxString() function

MaxString(some_value)

Re: How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Fri, 26 Feb 2016 03:46:38 GMT

thank you .. it works

Re: How to compare the same field values which differs but it has common primary key ?

Anonymous — Fri, 26 Feb 2016 04:32:58 GMT

MaxString(some_value) or FirstSortedValue(DISTINCT some_value, -primary_key )

Re: How to compare the same field values which differs but it has common primary key ?

Digvijay_Singh — Fri, 26 Feb 2016 05:39:53 GMT

FirstSortedValue won't work here, as for duplicate values of primary key it will show null in expression.

Re: How to compare the same field values which differs but it has common primary key ?

nishanthi_8 — Fri, 26 Feb 2016 05:46:56 GMT

THANKS IT WORKS

Re: How to compare the same field values which differs but it has common primary key ?

Anonymous — Fri, 26 Feb 2016 17:48:56 GMT

Hi Nishanthi,

Please take a moment to mark a reply as Correct in order for the thread to show as Answered. You can also mark other replies as Helpful if they assisted you.

Take a look at this document for more info: Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Qlik Community Moderation Team