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: 
Anonymous
Not applicable

Find and replace

Is there a function to find and replace some portion of script with another? In Qlik Sense

10 Replies
Kushal_Chawda

Can you please elaborate with scenario?

Anonymous
Not applicable
Author

I have used a set analysis in multiple sheets.

One of the parameters (LFL_flag) has changed its name (LFL_flag_weekly).

Is there an easy way to search through the whole app and see in what sheets and objects my parameter has to be updated with a new name.

undergrinder
Specialist II
Specialist II

Hi Marat,

There is a search/replace feature in data load editor.

2016-04-29 13_04_21-batch _ Data load editor - Qlik Sense.png

You can check the search in all section, and it will be done in every section of code. At the left pane you can see the occurences of searched expression.

However you can search/replace only one row per action.

G.

Anonymous
Not applicable
Author

Thanks for reply. So in scripting it is possible.

What about in sheets/objects (i.e. app editing mode)?

undergrinder
Specialist II
Specialist II

I don't think so.

But with master items you should update the measures/dimensions once, instead of check every formula in sheets.

G.

Anonymous
Not applicable
Author

Yes, thank you. But what I need to change is in used in:

1) many master items

2) many individual objects

undergrinder
Specialist II
Specialist II

I think this isn't possible to achive easier than change the functions manually

bstevens122
Partner - Contributor II
Partner - Contributor II

Why don't you just alias the column back to the original name you used in the set analysis? That way nothing needs to be changed on the front end.

bwisealiahmad
Partner - Specialist
Partner - Specialist

I think your best call is to use the API to export this some way. I don't know specifically how to do it, but if you read here you can see people have tried to do something similar before.

Sense - Get 'Master items' details programatically