Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
thkarner
Partner - Creator III
Partner - Creator III

Performance Tuning / How to log (resolved) expressions?

Hi, I need to do some performance tuning in an Qlik Sense app.

Unfortunately the final, resolved expression is extremly complex due to cascaded variables being used.

Is there a way in Qlik Sense to log somewho the final executed expression by the engine?

Are there any other tools / best practices which could be helpful for performance tunig?

KR Thomas

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can get calculation timings to help with performance tuning using either of these tools.

1) QS Document Analyzer - Search Recipes | Qlikview Cookbook

2) DevTool extension -- https://github.com/erikwett/DevTool

That's an excellent question re seeing the complete expression after dollar sign expansion (resolved expression).  Easy to do in QlikView, not sure how to do it in Qlik Sense.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

9 Replies
YoussefBelloum
Champion
Champion

Hi,

Start by sharing the Main expression and the variables's expressions used in it.

thkarner
Partner - Creator III
Partner - Creator III
Author

Thanks for your reply, but I wouldn´t share hundreds of lines with the expressions and variables. Furthermore you would need to understand the datamodel for optimization. Too much efforts for all.

So coming back to my 2 questions

a) How to trace and get the final, resolved expression?

b) Which tools are available for performance tuning?

YoussefBelloum
Champion
Champion

Maybe rwunderlich‌ can take a look here ?

tomasz_tru
Specialist
Specialist

If there's only one level of nested variables:

1. Add Text & Image object

2. Add a measure to it

3. Set an expression for the measure enclosed in single quotation marks:

     Example:  'SUM($(vYourNastyVariable))'

Variable should expand as a text and whole expression will be seen before execution.

4. If there's more expressions, you can compile long expression for Text & image' in excel. For example:

'SUM($(vYourNastyVariable))' & chr(10) & 'SUM($(vYourSecondNastyVariable))'

Tomasz

thkarner
Partner - Creator III
Partner - Creator III
Author

Hi Tomasz, thanks, I also thought about this approach, but I´ve nested variables in ~5 levels. Not sure if your your approach would resolve all levels of variables to the final full expression?

tomasz_tru
Specialist
Specialist

Only one level I've got the same case in one application - never again.

thkarner
Partner - Creator III
Partner - Creator III
Author

If I´m not mistaken the levels are not the issue. I´m using ' (single-quotes) in my variables. If I then try to get the expression like '$(vYourNastyVariable)' it returns me nothing. I guess it´s because auf the single-quotes.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can get calculation timings to help with performance tuning using either of these tools.

1) QS Document Analyzer - Search Recipes | Qlikview Cookbook

2) DevTool extension -- https://github.com/erikwett/DevTool

That's an excellent question re seeing the complete expression after dollar sign expansion (resolved expression).  Easy to do in QlikView, not sure how to do it in Qlik Sense.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

thkarner
Partner - Creator III
Partner - Creator III
Author

Thanks, will have a look to QS Document Analyzer. DevTool I already checked.

I´ll think further about resolving the cascading $()-expansion to the full expression including variables containing single- and double-quotes.