Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.