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: 
adimiz123
Contributor III
Contributor III

Performance with Set Analysis. Number VS String

Hi everyone 

I'm trying to improve App performance, a lot of the "Set Analysis" are with a string. 

I wonder if switching to a number will improve performance

for example -  

Now  --> Count ({<approved = {'yes'}>} Orders)

Change to -- >  Count ({<approved = {1}>} Orders)      (1 = Yes , in Data model)

Will it improve? In reality the formulas are longer...

I would love to know if there is a tool or way to measure performance improvement

 

Thanks 

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In set analysis, there is no difference in performance between using string and numeric for modifier values.  The internal logic always uses a string test. 

You can measure expression performance in your app using QSDA Pro.  Another tool for doing command line expression performance testing is CubeTester.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

 

adimiz123
Contributor III
Contributor III
Author

Thank you Rob !