Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paolo_mapelli
Contributor

DATE function causing QVF to crash

Good Morning,

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) ?

Thanks.

Paolo.

1 Solution

Accepted Solutions
paolo_mapelli
Contributor

Re: DATE function causing QVF to crash

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.

Thanks Marcus for suggestions.

Paolo.

3 Replies
MVP & Luminary
MVP & Luminary

Re: DATE function causing QVF to crash

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.

- Marcus

paolo_mapelli
Contributor

Re: DATE function causing QVF to crash

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

Paolo.

paolo_mapelli
Contributor

Re: DATE function causing QVF to crash

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.

Thanks Marcus for suggestions.

Paolo.