topic Re: Need help with set analysis in QlikView

Need help with set analysis

trishita — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 05 Jun 2018 14:29:00 GMT

How about this?

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

YoussefBelloum — Tue, 05 Jun 2018 14:29:28 GMT

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 — Tue, 05 Jun 2018 14:36:04 GMT

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 — Tue, 05 Jun 2018 14:41:00 GMT

its not working..no values in the column

YoussefBelloum — Tue, 05 Jun 2018 14:43:53 GMT

you can maybe try this:

Anil_Babu_Samineni — Tue, 05 Jun 2018 15:03:54 GMT

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