Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
pokermon
New Contributor II

syntax - function / expression / set analysis

Hi,

Slightly confused over syntax and maybe naming conventions...

Is a set analysis formula the same as entering a formula in the expression or function(fx) field (of lets say a bar chart or KPI object)?

I have watched quite a few of the Qlik videos and was under the impression that when typing in a forumla in the 'fx' field I should be using curly braces, square brackets etc. Yet I have seen a number of formulas that work just fine without any of that

e.g.

sum(sales)

Count(if(Male='true',Employee))/count(Male)

Sum(if(inventory<>counted,1,0)

- not a curly brace in sight

yet a curly brace is used here

Count({<Status = {"DONE"}, Approved= {"YES"}>} PERSON_ID)


If these are two separate 'things', i.e. entering a formula is not the same as set analysis, then is there help on the syntax's for both, with examples somewhere?


Hope i'm being clear....

Thanks,

Pokes

1 Reply

Re: syntax - function / expression / set analysis

Set analysis is used to show results outside of your selections. You can look here for a basic introduction to set analysis

A Primer on Set Analysis