Qlik Sense and SaaS: Prevent the creation of two Master Measures with the same name
Attachments
In Qlik Sense and in SaaS it is possible to create two or more Master Measures with the same name. Sense does no show any errors or warning but, if you use that Measure name in a formula, you get a generic error in the formula editor and incorrect results. This happens because Sense cannot understand what of the Master Measure to use.
I would suggest to introduce a warning that prevents the use of Master Measures with the same name.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
Turns out this is also a problem if you have a field and Master Item with the same name, so this feels a bit more like a bug/missed scenario rather than an idea. Given the features of Master Items, i.e., assigning colors, labels, formatting, etc, there are definitely going to be duplicates between fields and Master Items (i.e., replicate the existing field as a MI to gain the additional features). The issue here is slightly different but with a similar result where it seems to be that the Master Item starts to refer to itself as it interprets the field in the MI definition as a MI and creates a circular reference.
Yes, it's effecting all expression including the color formatting. All color using the field Name (measure label in chart/table) all not working properly.
Creating master item for all formula also not a very good solution as most of the measure expression is based on KPI of the dashboard and might not the same between the sheets but it might have the same measure label/column name, example: CY and LY and %Growth. Where this is very common in every sheet but the formula inside might be differ between the sheet as it's depend on the KPI of the sheet presentation.
Thank you all 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 by commenting and liking.
- I cannot see any good reason for two master items having the same name (very bad idea!)
- I cannot see any good reason for a master item having the same name as a field (also very bad idea!)
@Patrik: Can you not just add some validation to stop these situations when a master item is being being created in the future - if people have already done it that can stay and they can fix it as required so this change would not stop anything working in the way it did before the addition of the validation (and of course would not fix the problems seen above which will require the names to be changed).
This bug tripped me up the other day, when I inadvertently added a master measure with the same name as a dimension. It took me a while to understand why my charts were broken.
This should be prevented from happening with a validation check, as suggested above.
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.
