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

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

jblomqvist — Thu, 11 Jul 2019 13:16:53 GMT

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)

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

bramkn — Thu, 11 Jul 2019 13:26:55 GMT

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.

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

jblomqvist — Thu, 22 Aug 2019 12:01:08 GMT

Thanks for the tip on quotes!

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

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

tresB — Thu, 22 Aug 2019 12:35:52 GMT

Always! Numeric comparison would be faster than string comparison.