Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ma_zebra
New Contributor

Find and replace

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

Tags (1)
10 Replies

Re: Find and replace

Can you please elaborate with scenario?

ma_zebra
New Contributor

Re: Find and replace

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
Valued Contributor II

Re: Find and replace

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.

ma_zebra
New Contributor

Re: Find and replace

Thanks for reply. So in scripting it is possible.

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

undergrinder
Valued Contributor II

Re: Find and replace

I don't think so.

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

G.

ma_zebra
New Contributor

Re: Find and replace

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

1) many master items

2) many individual objects

undergrinder
Valued Contributor II

Re: Find and replace

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

bstevens122
New Contributor

Re: Find and replace

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
Valued Contributor

Re: Find and replace

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

Community Browser