1 Reply Latest reply: Mar 13, 2017 4:30 AM by Sunny Talwar RSS

    syntax - function / expression / set analysis

    Leo Harper

      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