topic Need Help in variable.. in QlikView

Need Help in variable..

Thu, 29 Mar 2012 11:18:23 GMT

Hello All,

In my applications year is displaying 2010,2011,2012 only.My financial year-end is March-2012.

In my applications they taken year=2012. now i created variable

LET CURRENT_YEAR = (YEAR(YEARSTART(NUM(TODAY()),0,4))+1);

LET CURRENT_MONTH = IF(NUM(MONTH(NUM(TODAY())))>3,NUM(MONTH(NUM(TODAY())))-3,NUM(MONTH(NUM(TODAY())))+9);

it is showing year=2012 and month=12 now it is correct,but what happen for next month(i.e.,after financial year-end).this will work.

can any one give some idea for creating variable,i.e.,it will displays in text box in my final appilication like date-month-year is 01-Apr-2012.

jagan — Thu, 29 Mar 2012 11:31:07 GMT

Hi,

Check this expression.

=Date(YearStart(Today(),0, 4), 'DD-MMM-YYYY')

Regards,

Jagan.

CELAMBARASAN — Thu, 29 Mar 2012 12:02:09 GMT

I think current financial year is 2011 then this should be (no need +1)

LET CURRENT_YEAR = YEAR(YEARSTART(NUM(TODAY()),0,4));

Check with this

=Date(AddMonths(YearStart(MakeDate(CURRENT_YEAR,CURRENT_MONTH),0,4),1+CURRENT_MONTH), 'DD-MMM-YYYY')