topic Expression syntax in QlikView

Expression syntax

Tue, 04 Jan 2011 15:45:16 GMT

Is there a good post or reference for QlikView expression and variable syntax? The online Help is not really adequate and the forums have formulae but not much in the way of explanations.

(if(column(1),count({<Team=,NAME=,Role={'Solution Author'}>} distinct CASE_ID)) - column(7))

Why the < {, when do I need < > and { } along with single and double quotes.

Appreciated.

David Rowe

Expression syntax

Miguel_Angel_Baeyens — Tue, 04 Jan 2011 16:10:59 GMT

Hello David,

The things between "{" and "}" in an aggregation function (sum, count, avg) are called Set Analysis (can be found in par. 20.4 Book III Ref. Manual for v9 SR6) . There is some documentation in the Reference Manual (referring, for example, to the set modifiers which go between "<" and ">"). Quoting is among others in par. 21.6 Book I of the Ref. Manual (v9 SR6). But for set analysis, numbers don't need quoting (nor variables which dollar expansion results on a number), literals ("strings" need single quotes, and search strings ("A*" meaning all starting in A) is enclosed with double quotes. An example would be

Count({< Year = {2010}, CompanyName = {"A*"}, Country = {'FR'} >} ID)

Besides, look into the "Training" section at the top of the page, there are some webinars (at least) regarding Set Analysis.

Hope this helps.

Expression syntax

Oleg_Troyansky — Tue, 04 Jan 2011 17:04:49 GMT

In addition to Miguel's suggestion:

Specifically for Set Analysis, a Help Article called "Set Analysis" (you can find it by searching the Help section for "Set Analysis") is an invaluable source of information. In the beginning, I used to print out this article every time I had to develop a Set Analysis solution, and to read the explanations and the examples. I used to so it for about a year, until all the terms had settled well in my memory 🙂

Expression syntax

Wed, 05 Jan 2011 13:52:23 GMT

Thanks guys. I'll see what I can dig out.