topic Re: KeyWord Syntax in QlikView

KeyWord Syntax

bjsellers57 — Tue, 16 Jun 2015 13:03:03 GMT

Performance associated with Syntax

When typing in KeyWord syntax in QlikView the KeyWord will be provided in various text formats to choose from (i.e. some all upper, some mixed case, some all lower case). Even so, majority of the typed KeyWords used are accepted, for Example LOAD (is all upper per QlikView), but < load > or < Load > are accepted. I heard sticking to the exact KeyWords is best practice in your code (backend and frontend) and will provide the best performance, is this true? As the underlying code must do additional translations if you deviate from the provided exact syntax.

I have used: (exambles of deviations)

'AS' when QlikView suggests 'as'
'Load' when Qlikview suggest 'LOAD'
'If' when Qlikview suggests 'IF'
'Drop Table' when QlikView suggests 'DROP Table'

Re: KeyWord Syntax

giakoum — Tue, 16 Jun 2015 13:11:03 GMT

I don't know if the upper or lower case makes a performance difference.

what I do know is that Sum(Sales( and sum(Sales) for example are different expressions for QlikView, so the server does not use it's cache to evaluate them but creates separate cache for each.

That has a performance impact, especially for complicated expressions or high data volume.

Re: KeyWord Syntax

prashantbaste — Tue, 16 Jun 2015 13:17:59 GMT

Hi Bernard,

Case sensitivity will not reflect performance in Qlikview.

But yes this is best practice which helps to make understand/highlight operations performed in coding & a reader can easily identify it. But there is no relation between Case sensitive keywords and performance of script.

But as a good programmer, one should keep habit of writing a neat & clean code with proper+simple syntax.

Complicated/Nested syntax affects on performance of application.

Please refer below link for more & better understandings.

https://community.qlik.com/servlet/JiveServlet/previewBody/7343-102-1-9596/Best%20Practices%20in%20Data%20Modeling.pdf

Regards,

Prashant P Baste

Re: KeyWord Syntax

Tue, 16 Jun 2015 13:18:15 GMT

During script execution these differences will have no impact, I would say whichever you go with, be consistent and use use them across the whole script. Mixing your upper and lower cases around just looks a bit messy!