Select Latest Data

[Gabbar]

I want only latest data to be shown,

Now if suppose no date filter or a filter in which both of those can come is selected than only row number 1 should be visible as that is the latest one with latest created on,
If Date range is selected upto date 44830(which excludes row 1) then only row 2 should be selected.

Please Help

[vinieme12]

use firstsortedvalue()

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ba...

Dimension

Count

LicenseNo

Measure

firstsortedvalue(LicenseType,-LicenseCreatedOn)

firstsortedvalue(LicenseCreatedOn,-LicenseCreatedOn) 

[Gabbar]

I am unable to do it dont know where i going wrong with equation.