Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
varma8998
Contributor III
Contributor III

How to get the max Month in Set analysis

Hi All,

How to get the Max Month in Set analysis

Table Format

HPA Month   Series   Value

December     123      4578

December     456      6735

November     789      8567

November     657      7894

November     876     6504

October         345      7867

Sum({<[HPA Month]={'$(=MaxString([HPA Month]))'}>} Value)

I took the same code but I am not getting the value instead of December value I am getting the October value

Please help me with how to get the December value

I tried with all the below mentioned codes

Sum({<[HPA Month]={'$(=MaxString([HPA Month]))'}>} Value)

Sum({<[HPA Month]={$(=MaxString([HPA Month]))}>} Value)

Sum({<[HPA Month]={$(=Max([HPA Month]))}>} Value)

Sum({<[HPA Month]={'$(=Max([HPA Month]))'}>} Value)

2 Solutions

Accepted Solutions
Mauritz_SA
Partner
Partner

Hi @varma8998 

I think the problem is that your [HPA Month] is being evaluated as text and there is no way for Qlik to know the ranking of text. You first need to convert it to a month using Date#(), evaluate it using Max() to get the highest one and then format it as a month using Date(). This should work:

Sum({<[HPA Month]={'$(=Date(Max(Date#([HPA Month],'MMMM')),'MMMM'))'}>} Value)

Hope this helps.

Regards,

Mauritz

View solution in original post

tresesco
MVP
MVP

Try like:

Sum({<[HPA Month]={'$(=Date(Max(Date#([HPA Month], 'MMMM')), 'MMMM'))'}>} Value)

View solution in original post

2 Replies
Mauritz_SA
Partner
Partner

Hi @varma8998 

I think the problem is that your [HPA Month] is being evaluated as text and there is no way for Qlik to know the ranking of text. You first need to convert it to a month using Date#(), evaluate it using Max() to get the highest one and then format it as a month using Date(). This should work:

Sum({<[HPA Month]={'$(=Date(Max(Date#([HPA Month],'MMMM')),'MMMM'))'}>} Value)

Hope this helps.

Regards,

Mauritz

View solution in original post

tresesco
MVP
MVP

Try like:

Sum({<[HPA Month]={'$(=Date(Max(Date#([HPA Month], 'MMMM')), 'MMMM'))'}>} Value)

View solution in original post