Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to add a calculated field without unlocking script manager

Hi,

It's not obvious for me, so I ask. How can I add calculated data to a table using script editor without loosing the chance to edit it in data manager?

I.e. I have date field DocumentDate and I would like to add another date field that is based on existing DocumentDate field. But I don't want to change and unlock the section generated automatically by data manager. Is it possible in script manager?

Maciek

2 Replies
Highlighted
Creator III
Creator III

Hi,

use the auto generated table in resident load with the manipulations you need and then drop it.

You need to add new section in the script and move it below the auto generated part and put the script there.

BR,

  Matus

Highlighted
Creator
Creator

🙂 Very tricky, thanks, it solves my problem.

I would like to ask also three questions:

Is it a common situation that auto-generated section is being unlocked or this is a rare case?

It causes new situation when I delete original tables, which I haven't met before, that I can't edit connections between tables in data model editor is it also a common situatution/consequence? Can I edit it in some different way?