Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
jblomqvist
Valued Contributor

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
Partner
Partner

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

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
Valued Contributor

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

Thanks for the tip on quotes!

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

MVP
MVP

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

Always! Numeric comparison would be faster than string comparison.