Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Reply
Not applicable
Author

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