Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Duplicate date problem


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

Have a look at the FirstSortedValue()