syntax - function / expression / set analysis

[Anonymous]

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

[sunny_talwar]

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