Suggest an Idea

[bugsysiegals]

I've about 30 unique KPI's in a dashboard which exist for 5 different regions so about 150 master items.  They all use a similar if statement to calculate time period of analysis and have only the region and KPI which are unique per KPI.  I've had to make mass changes on many occasions during development which takes an extraordinary amount of time ... it really drives me crazy when I need to make a mass change knowing I could do a simple find/replace or export, find/replace in Excel, import in 10 minutes or less versus several hours of tediously changing and not knowing if I missed something, etc.  Is there some tool which exists already or can we please get this added soon!?

Ex.

if(Analysis='MTD', Sum({<Region={'NA'},YearMonth={"$(=vMaxYearMonth)"}>}[Depot Labour Productivity]),
if(Analysis='PMTD', Sum({<Region={'NA'},YearMonth={"$(=vPreviousYearMonth)"}>}[Depot Labour Productivity]),
if(Analysis='YTD', Sum({<Region={'NA'},Calendar.FL_YTD={1},YearMonth=>}[Depot Labour Productivity]),
if(Analysis='PYTD', Sum({<Region={'NA'},Calendar.FL_PYTD={1},YearMonth=>}[Depot Labour Productivity]),
if(Analysis='PY', Sum({<Region={'NA'},Calendar.FL_PY={1},YearMonth=>}[Depot Labour Productivity]),'')))))

[John_Teichman]

Hello @bugsysiegals,

Thank you for your post. This concept has been submitted in previous idea posts:

1. Search & Replace - https://community.qlik.com/t5/Ideas/Search-and-replace-for-master-library/idi-p/1645594
2. Find "broken" master items - https://community.qlik.com/t5/Ideas/Find-out-broken-Master-Items/idi-p/1671860

Please show your support for those ideas by liking (voting for) them.

Also, going forward, please use one and only one label when submitting an idea. Please refer to the submission guidelines for more details.