Need help with set analysis

[trishita]

I am new to QLIKVIEW  and I want to show the latest value of the field FUEL PER LAST NOON on the following code:

max(

{<

    SURVEY_DATE   = {"$(=max(SURVEY_DATE_NUM))"}

>}

[Fuel per most recent Report]    )

This is the set of  records on which i want to use the code

[Anil_Babu_Samineni]

How about this?

FirstSortedValue([Fuel per most recent Report], -SURVEY_DATE)

[YoussefBelloum]

Hi,

what do you mean by: I want to show the latest value of the field FUEL PER LAST... ?

do you mean the latest loaded value ? the latest value by Survey_date ?

[trishita]

yes for example in the example we can see the latest value is the maximum value 4049.900 which is also the cumulated maximum value as per survey_date

[trishita]

its not working..no values in the column

[YoussefBelloum]

you can maybe try this:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringAggregat...

[Anil_Babu_Samineni]

Column? Where you are trying this. Can you share sample application