topic Re: date set analysis in QlikView

date set analysis

Thu, 29 May 2014 11:19:39 GMT

Hi All , i have 2 questions:

first: i have this set: sum({$<Year={$(vCurrentYear)}>}Sales.Amount), it sales for each month of current year (month is a dimmension, vCurrentYear variable =Year(Today()) ), i get results for 2014 jan, 2014 feb etc, till current month (may), but i wont to see current month, and i try this set but it dosnt work: sum({$<Year={$(vCurrentYear)},Month={" <$(=vCurrentMonth)" }>}

vCurrentMonth variable = Month(Today())

second: i have this variable, it returs me current month:

vCurrentMonth variable = Month(Today())

how ican declare variable wich returs me previuos year month?

vCurrentMonth variable = Month(Today()) = 2014 May

vPreviousYearMonth variable = ?????? = 2013 May

Please help.

Re: date set analysis

tresB — Thu, 29 May 2014 11:22:18 GMT

vPreviousYearMonth = MonthName(AddMonhts(Today(), -12))

Re: date set analysis

Anonymous — Thu, 29 May 2014 11:24:01 GMT

To get Previous Year Month

Let vPrevYrMonth = MonthName(AddYears(today(),-1))

Regards

Nitin

Re: date set analysis

brijesh1991 — Thu, 29 May 2014 11:25:13 GMT

Let vPrevYrMonth = MonthName(AddDays(today(),-365))

ha ha ha... nititn!!!

tresco

Re: date set analysis

Anonymous — Thu, 29 May 2014 11:27:12 GMT

This can be wrong if there is a leap year in between...................