topic Re: Set analysis and current month in QlikView

Set analysis and current month

Wed, 22 Jan 2014 06:36:46 GMT

Hi ALL,

i want sum my sales for currentmonth, how can i do his?

sum( {$<Month(maxMonth>} Sales.Amount) not working

pleae help

Re: Set analysis and current month

tresB — Wed, 22 Jan 2014 06:39:12 GMT

May be like:

Sum({<MonthField={"$(=Max(MonthField))"}>} Sales.Amount)

Assuming your monthfield is created in the script using month().

Re: Set analysis and current month

sujeetsingh — Wed, 22 Jan 2014 06:41:21 GMT

sum( {$<Month={$(=Month(maxMonth))}>} Sales.Amount)

Re: Set analysis and current month

Wed, 22 Jan 2014 07:08:00 GMT

still not working, my master calendar script is:

UNQUALIFY *;

Min:

LOAD

min (Date) as MinDate

resident Fact;

Max:

LOAD

max (Date) as MaxDate

resident Fact;

vMinDate = Peek('MinDate',0,'Min');

vMaxDate = Peek('MaxDate',-1,'Max');

Temp:

LOAD

date($(vMinDate) + RowNo() - 1) as Date

AutoGenerate

$(vMaxDate) - $(vMinDate) + 1

;

Calendar:

Load

Date as Date,

Month(Date) as Month,

Year(Date) as Year,

Week(Date) as Week,

WeekDay(Date) as WeekDay,

Day(Date) as Day,

'Q'&Ceil(Month(Date)/3) as Quarter,

'H'&Ceil(Month(Date)/6) as HalfYear,

MonthName(Date) as YearMonth,

Year(Date) &'-Q'& Ceil(Month(Date)/3) as YearQuarter,

Year(Date) &'-H'& Ceil(Month(Date)/6) as YearHalfYear

resident Temp;

drop tables Min,Max,Temp;

Re: Set analysis and current month

tresB — Wed, 22 Jan 2014 07:12:03 GMT

This?

Sum({<Month={"$(=MaxString(Month))"}>} Sales.Amount)

Re: Set analysis and current month

Wed, 22 Jan 2014 07:17:55 GMT

works great, thanks