topic seelction max in QlikView

seelction max

soniasweety — Sat, 16 Nov 2024 02:28:51 GMT

Hi all, Vegar

i have a region filed AMS,APJ,EMEA

and month 201601 201602 ,201603,201604,201605,201606,201607....201707

when i select region for AMS max month is 201707 to be selected (as data present for AMS 201707 is max data month)

when i select for EMEA max month is 201707 to be selected (as data present for AMS 201707 is max data month)

but when i select APJ max month is 201607 as we have data for APJ with max month is 201607 how i can i do this?

Re: seelction max

DavidM — Mon, 16 Sep 2019 10:03:28 GMT

I think you need to specify max month for each region by creating Max field in load script and use that for filter (or in set analysis). Something like this:

Load

Max(Month) as MaxMonth,

Region

Resident Data

Group by Region;

Re: seelction max

soniasweety — Mon, 16 Sep 2019 10:07:58 GMT

i have only one moth field we need to use in front end.

it should be selected default when user selected on perticular region