I was designing a flat table object into a QlikSense Desktop app's sheet (v. 2.0.2) and trying to use "DATE(<a date valued field>,'WWWW')" as a dimension column to retrieve the name of the day.
Now my QVF crashes everytime I click on the sheet the table is included in, both in show and design mode.
Is there a way to edit the sheet, removing that table object (causing app crashing), without having data loaded (refreshing) on sheet selection ?
Or, eventually, a way to retrieve all the scripting code included in other objects embedded in that sheet (that I don't want to get lost) ?
Solution found: I truncated the table in the database. In this way, with zero record returned by the query in the script, the flat table hasn't reloaded and I successfully removed the column with the abovementioned function.
Similar things happens with qlikview too. I suggest to avoid such calculated dimensions and using native fields created within a master-calendar: How to use - Master-Calendar and Date-Values.
Hi Marcus, fine on problem cause (I've tried on another, new, app and it seems strictly related to "WWWW" format output), but now I need a solution for the problem...
Trying to understand why such a bugged function keeps to be available...
Solution found: I truncated the table in the database. In this way, with zero record returned by the query in the script, the flat table hasn't reloaded and I successfully removed the column with the abovementioned function.
