Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Disappearing Script Tabs

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?

Tags (3)
1 Reply
Not applicable

Disappearing Script Tabs

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 " "

Community Browser