topic Re: Max Month in QlikView

Max Month

NavinReddy — Wed, 02 Apr 2014 17:09:24 GMT

Dear All,

I have Data it has only Feb data

but i need to show current month is FEB only 2014, i have 2013 and 2014 data also

How Can i Feb Data Like Current Month

Im Using Max(Month) its not working i want to show in expression current month data

Please find the attechment

Thanks in Advance

Niranjan

Re: Max Month

its_anandrjs — Wed, 02 Apr 2014 17:15:29 GMT

Use months =month(AddMonths(Today(),-1))

Re: Max Month

chiru_thota — Wed, 02 Apr 2014 17:16:43 GMT

Max(Month) won't work as it is not a numeric value.

Maintain one more column called MonthNo and use it in your expression.

Ex : Load Inline

[

Month,MonthNo

Jan,1

Feb,2

.......

Re: Max Month

swuehl — Wed, 02 Apr 2014 17:18:19 GMT

I think the way to go here is not using only the month name (or month name and year in separate fields), but create a field that is in fact a date (like a monthstart), you can create such a field e.g. by using

makedate(YearField, MonthField) as MonthStart,

in your load script (MonthField needs to be numeric here).

Then max(MonthStart) will select the records for the current month.

Re: Max Month

its_anandrjs — Wed, 02 Apr 2014 17:20:37 GMT

Add one more field as a Year then you you have to check max date.

Re: Max Month

NavinReddy — Wed, 02 Apr 2014 17:30:11 GMT

yes i used same expression but if they delay one month means

current month it will disply blank

Re: Max Month

NavinReddy — Wed, 02 Apr 2014 18:11:22 GMT

Hi Swuehl,

This expression fetching both the month values how can i fetch only

FEB Month

Please help me

Sum({1<Month={"<=$(=Max(Month))"},Year={'2014'}>}PAY_AMT)

Thanks,

Niranjan

Re: Max Month

NavinReddy — Wed, 02 Apr 2014 18:30:18 GMT

Hi Anand,

Where can i add year field

Thanks,

Niru