Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Sameer9585
Creator II
Creator II

Duplicate date problem

Hi,

I have a dataset in this way that it contains date, currency, rates and it contains some date same with different rates means ex for 1/1/2019 its rate is 75 and 74 but here the condition is that currency is of two types USD and EUR so it is giving me total 4 values of date 1/1/2019 but I require only the updated one of the rate,date and currency.

Thanking you in advance,

With Regards,

1 Reply
tresesco
MVP
MVP

Have a look at the FirstSortedValue()