idea Re: Measures/Dimensions/Expressions Repository in Suggest an Idea

Measures/Dimensions/Expressions Repository

Stoyan_Terziev — Wed, 25 Nov 2020 08:53:26 GMT

Basically, the idea is to create a repository for all formulas used in Qlik Sense Non-published apps. Not just master items, but I won't be surprised if it should start there from UI standpoint.

Inspiration: QlikView had this Expression Repository which you can use to export and search on top of all expressions used in the app.

The problem: We need to do bulk search and update formulas, so we want to be able to find where a certain field, measure, variable or set expression is used. Even bulk update of formatting.

Solution 1 (should be easy): Create "Bulk Explore" functionalities for each of the Master Items sections to filter among all the expressions, dimensions, extensions, visualizations based on their name, values, tags or descriptions. ++ Export to excel

Solution 2 (a bit more nasty): Create a "Bulk Explore" that spans a table with all the formulas used explaining if it's used in a Variable, Master Measure, Master Dimension, Custom Dimension, Expression, Color, Range, etc, etc, value. ++ Export to excel

Solution 3 (must be the nastiest): Solution 2 + Bulk update functionality. Basically Find/Replace.

I hope I'm not duplicating anyone's idea. But even if so, let's make this hot!

It was quite heavily used in QlikView.

Re: Measures/Dimensions/Expressions Repository

dimitar_dekov — Thu, 08 Oct 2020 15:59:06 GMT

I recently had to modify some expression just by a tiny bit, but the new filter had to be added to several dozens of KPIs. Took me about an hour, while I can imagine that if we had a true Measure / Dimension repository, I could have used some find and replace functionality.

Re: Measures/Dimensions/Expressions Repository - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 10 Nov 2020 12:47:45 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Meanwhile it is possible to use tools like Rob Wunderlich's QCB-QLIK-SSE to maintain master items.

Thanks,
Patric

Re: Measures/Dimensions/Expressions Repository

juraj_misina — Thu, 10 Dec 2020 17:17:49 GMT

Yes, we need a Qlik Sense version of Expression overview: https://community.qlik.com/t5/Ideas/Search-and-replace-for-master-library/idi-p/1645594

Re: Measures/Dimensions/Expressions Repository

devan9876 — Wed, 06 Jan 2021 02:42:10 GMT

@juraj_misina

In case you're interested, I did create an extension that has bulk update and find/replace functionality for variables and master items.

I'm not really a programmer by trade and it was kind of a home project that I haven't touched since they got rid of the free Qliksense desktop license but it seemed to work back when I made it.

https://developer.qlik.com/garden/5f33685d6e4c3e00113d0c5a

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:44:19 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Measures/Dimensions/Expressions Repository - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:44:20 GMT