Need a List of All Measure Values in App

[Steve_Rosebrook]

We have a very large app with over 500 measures in it.  We'll soon be making some global changes that will impact several hundred measures.  The changes will be fairly easy - but the validation will be hard.  What I'd really like to have is a table on a sheet in the app that lists out all the measures in the app, and what the current value is (see attached mock-up I made).  That way we can do an easy before and after comparison on the values being returned.

I'm just striking out with every attempt I've made at creating this kind of table.  I've tried an island table of measures along with dollar-sign expansion.  I've tried using ValueList and ValueLoop.  So far nothing is working (at least nothing that can scale up to 500+ measures).  I have a list of all the measure names that I can insert into an island table in the app, if that's needed.

I'd love to hear anyone's thoughts on whether this is even possible - seems like a fairly reasonable ask.  Thanks in advance for the help!

[Or]

You could just stick all of these measures into a Straight Table and export that, perhaps? You could use other object types, but the new Straight Table has the advantage of allowing you to do a select-all on measures, which seems like it'd make the whole thing a breeze.

[Steve_Rosebrook]

I should have mentioned: we're on the August 2022 Windows version - so I don't think the straight table has that functionality in our version, unfortunately.

[marcus_sommer]

I'm not sure if the approach itself is expedient respectively could be simplified significantly. This means I wouldn't tend to it else just saving only the results of the main-expressions, like:

sum(Sales) or count(distinct Products)

against Years and/or a Category or similar dimensions but not all the YTD, LYTD and so on stuff. That they would work like before could be checked separate against the calendar-tables and/or as-of-tables with appropriate flags and/or offset-values. If none such logic is implemented I suggest to use the occasion to re-design the UI.

[piotr-bratek]

Hi Steve,
have you tried AddSense chrome extension? Well maybe it's not exactly  what you need but it's super easy and super quick when you need to validate these formulas. The only downside is you will not see dollar-sign expansion result directly but you can either copy or download the table with all measures in your app and do it in another app - it seems it's still quite fast ...

0 - add Add Sense to chrome
1 - open Add Sense and qlik Show
2 - click the Measures icon
3 - here's the list
4 - make a copy or download it

cheers

Piotr

[anat]

Thanks for the info... Very useful to get list of measures from qsense dashboard

[EliGohar]

You can try Qollect, my new & free Qlik Sense extension that pulls app metadata (Measures, Dimensions, Fields, Charts, Variables) and exports it to Excel. Great for quickly listing all measure expressions/labels/values.
Link: https://www.regarden.io/extensions/3170c06d-0cbb-462f-a3e6-5303f9763249