topic Re: Master Calendar load in QlikView

Master Calendar load

jjking58 — Sun, 18 Dec 2016 20:30:51 GMT

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

Re: Master Calendar load

maxgro — Sun, 18 Dec 2016 20:34:16 GMT

try to add a space in the select after IN

IN (2014, 2015, 2016);

Re: Master Calendar load

jjking58 — Sun, 18 Dec 2016 22:42:48 GMT

I tried that,but got the same result

Re: Master Calendar load

jjking58 — Sun, 18 Dec 2016 22:51:25 GMT

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

Thanks

Jim