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

[nishanthi_8]

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?

[nishanthi_8]

thank you .. it works

[Anonymous]

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

[Digvijay_Singh]

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

[nishanthi_8]

THANKS IT WORKS

[Anonymous]

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