Master Calendar load

[jjking58]

I'm hoping someone can help. I've tried using all the Qlikview suggestions i could fine on the internet and nothing seems to work.

I have a as/400 table called SROISH that i assigned a table name of 'InvHeader (image 1)'. I'm trying to create a Master Calendar under a script tab called 'Dates'(Image 2). I keep getting the following error when doing a reload and have no idea why(Image 3)

I appreciate any help.

Thanks,

Jim

[maxgro]

try to add a space in the select after IN

IN (2014, 2015, 2016);

[jjking58]

I tried that,but got the same result

[jjking58]

i figured it out. I was missing a semicolon after the last field in the file.

Thanks

Jim