topic Re: Need Help with Variable in QlikView

Need Help with Variable

Anonymous — Mon, 21 Mar 2016 21:32:19 GMT

Hi Guys

I am trying to put n a Variable but do not know how to do this.

I want a Flag if in the last 4 months CreatedDate was more than 4 months old to say Y and Older than 4 months to say N

I have attached a Test Script.

I can normally do this with months but this time the format is in DD/MM/YYYY so havent done this before.

Please see attached Qvw.

Thanks for the help!

swuehl — Mon, 21 Mar 2016 21:43:50 GMT

Are you looking for

Let vTest = AddMonths(Today(),-4);

maxgro — Mon, 21 Mar 2016 21:44:10 GMT

Let vTest = addmonths(today(1),-4);

maybe you have to chabge the test from this

If(CreatedDate >= '$(vTest)','Y','N') as Flag,

If(CreatedDate >= '$(vTest)','N','Y') as Flag,

Anonymous — Mon, 21 Mar 2016 21:50:16 GMT

Thanks Buddy!