topic Re: SYNTAX ERROR in QlikView

SYNTAX ERROR

upaliwije — Sun, 28 Jun 2015 22:40:48 GMT

Please correct following syntax in load script

IF(DUAL(YEAR(INT_DATE)<2015,'OTHER_YEARS',Month(INT_DATE) &'-'& YEAR(INT_DATE)),INT_DATE)As Month_Year,

sunny_talwar — Sun, 28 Jun 2015 22:59:34 GMT

May be this:

Dual(If(Year(INT_DATE) < 2015, 'OTHER_YEARS', Month(INT_DATE) &'-'& Year(INT_DATE)), INT_DATE) as Month_Year,

sunny_talwar — Sun, 28 Jun 2015 23:01:53 GMT

Not sure if this is how you want it to be, but you can also try something like this:

Dual(If(Year(INT_DATE) < 2015, 'OTHER_YEARS', MonthName(INT_DATE)), INT_DATE) as Month_Year,

Best,

Sunny

Anonymous — Sun, 28 Jun 2015 23:17:34 GMT

If I got the requirement right:

if(YEAR(INT_DATE)<2015, dual('OTHER_YEARS',0), Date(INT_DATE,'MMM-YYYY')) As Month_Year

The 0 here is for sorting, so the "other years" is on top. Date() is dual by nature.

jagan — Mon, 29 Jun 2015 02:43:12 GMT

Hi,

I think it should be

DUAL(IF(YEAR(INT_DATE)<2015,'OTHER_YEARS',Month(INT_DATE) &'-'& YEAR(INT_DATE)),MonthEnd(INT_DATE))As Month_Year,

Hope this helps you.

Regards,

jagan.

upaliwije — Mon, 29 Jun 2015 05:20:24 GMT

Thank you all