Performance Tuning / How to log (resolved) expressions?

[thkarner]

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

[YoussefBelloum]

Hi,

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

[thkarner]

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]

Maybe rwunderlich‌ can take a look here ?

[tomasz_tru]

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]

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]

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

[thkarner]

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 · Accepted solution]

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]

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.