Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Question for the Experts:Are numeric comparisons and clauses better than string value in Qlik Sense?

Hi,

Are numeric comparisons and clauses better than string value?

If so, why?

For examples instead of Sum({<Company={"Nike"}>}Sales)

Alternative:

Sum({<CompanyID={1}>}Sales)

3 Replies
bramkn
Partner - Specialist
Partner - Specialist

Don't know if there is a noticable performance difference. But You should use single quotes ' '  When checking for strings. Double quotes " " Are used for Searching values. With Wildcards for example.

jblomqvist
Specialist
Specialist
Author

Thanks for the tip on quotes!

If anyone can help with answering the numeric vs string it would be great.

tresesco
MVP
MVP

Always! Numeric comparison would be faster than string comparison.