topic Re: Variable in QlikView

Variable

Mon, 31 Aug 2015 10:09:42 GMT

Dear,

set vLockDate2='03-Sep-2015';

I set variable and assign value as above and want to show month end in another variable but its not show value as given below variable.
LET v2LockDate=MonthEnd(vLockDate2);

kindly guide how to show value.

Regards,

Zain.

Re: Variable

Digvijay_Singh — Mon, 31 Aug 2015 10:13:56 GMT

Try setting formatting, You may need to apply required format as per your need.

LET v2LockDate=Date(Date#(MonthEnd(vLockDate2),'DD-MMM-YYYY'));

Re: Variable

sunny_talwar — Mon, 31 Aug 2015 10:18:32 GMT

May be this:

LET vLockDate = Date#(03-Sep-2015', 'DD-MMM-YYYY');

LET v2LockDate = MonthEnd(vLockDate);

Re: Variable

maxgro — Mon, 31 Aug 2015 10:19:04 GMT

LET v2LockDate=MonthEnd(Date#(vLockDate2,'DD-MMM-YYYY'));

Re: Variable

Mon, 31 Aug 2015 10:28:00 GMT

Thanks Sunny, i have got result.

Zain.

Re: Variable

alexandros17 — Mon, 31 Aug 2015 10:28:51 GMT

LET vLockDate2='03-sep-2015';

LET v2LockDate = MonthEnd(Date#(vLockDate2,'DD-MMM-YYYY'));

Re: Variable

jagan — Mon, 31 Aug 2015 10:28:54 GMT

Hi,

Try like this

LET vLockDate2= MakeDate(2015, 9, 3);

LET v2LockDate=MonthEnd(vLockDate2);

Hope this helps you.

Regards,

jagan.

Re: Variable

Mon, 31 Aug 2015 10:32:39 GMT

TRY LIKE THIS

LET VEND=MonthEnd(DATE(date#('$(vLockDate2)','DD-MMM-YYYY'),'DD/MM/YYYY'))