Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting variable returns incorrect results?

Adding the following to my script in Sense 2.4 

LET vYearPreviousX2 = Year(YearStart(Today())-2);                 //Returns (2015)

LET vMonthPreviousX2 =  Month(MonthStart(Today())-2);        // Returns (Jun)

Returns the same results as:


LET vYearPrevious = Year(YearStart(Today())-1);                    // Returns (2015)

LET vMonthPrevious = Month(MonthStart(Today())-1);            // Returns (Jun)

Anything jump out at you?

1 Solution

Accepted Solutions
sunny_talwar

You are subtracting 1 or 2 days from your YearStart, which will only take you 2015. May be you need theses

LET vYearPreviousX2 = Year(AddYears(Today(), -2));                 //Should give you 2014

LET vYearPrevious = Year(AddYears(Today(), -1));                     //Should give you 2015

LET vMonthPreviousX2 =  Month(AddMonths(Today(), -2));        //Should give you May

LET vMonthPrevious = Month(AddMonths(Today(), -1));        //Should give you Jun

View solution in original post

2 Replies
sunny_talwar

You are subtracting 1 or 2 days from your YearStart, which will only take you 2015. May be you need theses

LET vYearPreviousX2 = Year(AddYears(Today(), -2));                 //Should give you 2014

LET vYearPrevious = Year(AddYears(Today(), -1));                     //Should give you 2015

LET vMonthPreviousX2 =  Month(AddMonths(Today(), -2));        //Should give you May

LET vMonthPrevious = Month(AddMonths(Today(), -1));        //Should give you Jun

Not applicable
Author

Yur result it´s the same because you subtracts 1 and 2 day of yearstart of today.

if you whant substract 1 or 2 year or months use the expression below:

Year(AddYears(Today(),-1)) = substract 1 year of year of today

Year(AddYears(Today(),-2)) = substract 2 year of year of today

Month(AddMonths(Today(),-1)) = substract 1 month of month of today

Month(AddMonths(Today(),-1)) = substract 2 month of month of today