Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Max

Hi guys

I have 2 years 2010 and 2011 , 2010 have months from jan to dec and 2011 have months from jan to Nov. 

I want the max(Month) of 2011 that is Nov  not Dec, when i  clear the selection

1 Solution

Accepted Solutions

Max

Hi,

     Simply use Month(Max(Date)) no need monthname in it.

Celambarasan

6 Replies
Not applicable

Max

Hi manish05,

You can use monthname() function or you can pass both year and month. So, max of month is selected from the particular year only.

.

Ashutosh

Not applicable

Max

Can you please give a example

Not applicable

Max

yeah sure,

Just give a sample app with your requirement so that I can give more accurate example.

Not applicable

Max

I don't have any app for it yaar ....  i just tried it with few values in excel with columns Sales and Date (m/d/yyyy).

Not applicable

Max

i have done like this

Month(MonthName(Max(Date)))  its working ....

is there any other way also???

Max

Hi,

     Simply use Month(Max(Date)) no need monthname in it.

Celambarasan

Community Browser