topic Re: Set Analysis to fetch associated field value based on Max Date in QlikView

Set Analysis to fetch associated field value based on Max Date

lightsection — Sat, 16 Nov 2024 00:34:33 GMT

I would like to fetch the last value of "Cummulative Revenue Budget CAD" based on selected date period flag (Selections shown on the left side of the screenshot)

Re: Set Analysis to fetch associated field value based on Max Date

vamsee — Sat, 30 May 2020 22:13:15 GMT

Try

Sum({<[Actual Date]={"$(=Max([Actual Date]))"}>}Cummulative Revenue Budget CAD)

Re: Set Analysis to fetch associated field value based on Max Date

lightsection — Tue, 09 Jun 2020 03:38:58 GMT

Thanks. that works !