topic Re: Max calendar or current selection Month in QlikView

Max calendar or current selection Month

didierodayo — Thu, 12 Oct 2017 03:16:00 GMT

Hello,

I would like to add the max month to a set analysis e.g. Sum({<??>}Sales). By default the max(Month) is the current calendar month e.g.October

otherwise Month Selections are made then it is the max(Month)of the selection. The Month Field is in this format.

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Thanks

Re: Max calendar or current selection Month

Anil_Babu_Samineni — Thu, 12 Oct 2017 03:17:57 GMT

Try anyone of these

Sum({<Month = {'$(=Max(Month))'}>} Sales)

Sum({<Month = {'$(=Month(Today()))'}>} Sales)

Re: Max calendar or current selection Month

its_anandrjs — Thu, 12 Oct 2017 03:30:34 GMT

In your data model add new field where you have month field create Num Month field

Ex:

Load

NUM(Month) as NumMonth

From source;

Expre:-

Sum({$<NumMonth = {"$(=Max(NumMonth))"},Year={"$(=Max(Year))"}>} Val)

Re: Max calendar or current selection Month

didierodayo — Thu, 12 Oct 2017 03:30:56 GMT

HI Anil,

That is what I have been having issue with.

Month(Today()) returns October when selections are made the value is then zero.

Max(Month) returns the maximum of whatever is selected Which means Dec can be selected because my data has months up to Dec. But I would like the Maximum month to be the current calendar month or below.

thanks

Re: Max calendar or current selection Month

Anil_Babu_Samineni — Thu, 12 Oct 2017 03:44:55 GMT

True, Even we need to degrade again using Maximum year because qlikview can associate default when filter on month. Now, You can try using Year={'$(=Max(Year))'}