topic Re: YearMonth if statement in QlikView

YearMonth if statement

dhgaimez — Wed, 09 Dec 2020 16:33:19 GMT

Hey all,

I am trying to use an if statement using YearMonth in relation to a calculated value and cannot get it working.

This is working
if(YearMonth = '2020-02',0,1)

Trying to get something like this to work.
if(YearMonth = Date(AddMonths(max(YearMonth), -6),'YYYY-MM'), 0, 1)

Date(AddMonths(max(YearMonth), -6),'YYYY-MM') outputs 2020-02

Can't figure out why this wouldn't work. Any help is appreciated!

Re: YearMonth if statement

edwin — Wed, 09 Dec 2020 18:56:03 GMT

it looks like you are comparing two different types, make both dates in your compare

Re: YearMonth if statement

MayilVahanan — Thu, 10 Dec 2020 06:41:13 GMT

Hi @dhgaimez

Try with variable for this .

ex:

vpast6Month = Date(AddMonths(max(YearMonth), -6),'YYYY-MM')

if(YearMonth = '$(vpast6Month)',0,1)

Hope it helps

Re: YearMonth if statement

pradosh_thakur — Thu, 10 Dec 2020 07:13:11 GMT

Try

if(YearMonth = text(Date(AddMonths(max(YearMonth), -6),'YYYY-MM')), 0, 1)

-Pradosh

Re: YearMonth if statement

edwin — Thu, 10 Dec 2020 16:11:38 GMT

as i said both side of the equation should have same data type convert both to date:

if(date(YearMonth&'-01') = AddMonths(date(max(YearMonth)&'-01'), -6), 0, 1)

you dont need the formatting to YYYY-MM