Getting the maximum date of the current selection

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

i am using following KPI in line chart

=Sum({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1},Mod_EquipmentStartDate={"<=$(=(Max(DateID)))"},Valid_From_Date={"<=$(=(Max(DateID)))"}>} EquipmentCount) +

sum({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'Y'}

,Flag ={1},Mod_EquipmentStartDate={"<=$(=(Max(DateID)))"},Valid_From_Date={">$(=(Max(DateID)))"}>} EquipmentCount)

Whenever i am putting following KPI in line chart ,

I am getting a different value for particular year if i made of selection of that year ,but without selection we are getting different value.

This is because when i am not selecting any year it is giving me overall maximum date of DateID ,But when i am selecting particulat year it is giving maximum date id of that year.

Can any one tell me how to modify this logic so that it compares only the particulat year maximum date id only when i am not making selection ?

Re: Getting the maximum date of the current selection

swuehl — Wed, 24 Oct 2018 08:36:42 GMT

The dollar sign expansion as well as set analysis is evaluated in global context, not per your chart dimensional values.

Is Year a dimension in your chart?

Then the current expression will not 'look' at the current dimensional Year value and use this to determine the max DateID, just as you've noted.

It's hard to give you a more precise help without knowing anything about your context, model and data.

topic Getting the maximum date of the current selection in QlikView

Getting the maximum date of the current selection

Re: Getting the maximum date of the current selection