Disappearing Script Tabs

Thu, 16 Sep 2010 14:27:51 GMT

I have written a report with 6 tabs in the script. I made a small change to the script, and pressed OK. When I went back into the script, the next tab was missing, and had been appended to the tab I modified, prefixed by ///$tab. No matter what I do, I can't reinstate the next tab. Has anyone else encountered this, and if so, how did you resolve it?

Disappearing Script Tabs

Thu, 16 Sep 2010 14:46:07 GMT

bumpity bump

I found my own solution. By replacing the lines:

SQL SELECT *
FROM DataWarehouse.dbo."View_ProductionOrderMovements#2(B)" WHERE [Plant]='5701'

...with...

SQL SELECT *
FROM DataWarehouse.dbo.[View_ProductionOrderMovements#2(B)] WHERE [Plant]='5701'

...the next tab could be reinstated. As soon as I put the " " back instead of the [ ] in combination with the parentheses on the SQL View name, the problem came back.

So the solution is to only use [ ] on table names, and not " "

topic Disappearing Script Tabs in QlikView

Disappearing Script Tabs

Disappearing Script Tabs