excluding null values in set analysis

ali_hijazi — Fri, 27 Jan 2012 07:49:49 GMT

Hello

I have an expression in which I want to calculate the sum of a field without taking into consideration the null values as follows:

sum (
       {$<
       Type={Sales},
       PeriodDate={"<=$(=vPeriodDate) >=$(=vCurrentYearStart)"},

          Emp_name -= {$(=null())}
       >}
       Sales$HT
       )

however I'm getting error in expression syntax; check attached

SunilChauhan — Fri, 27 Jan 2012 08:02:21 GMT

sum (
       {$<
       Type={Sales},
       PeriodDate={"<=$(=vPeriodDate) >=$(=vCurrentYearStart)"},

          Emp_name -= {}
       >}
       Sales$HT
       )

hope this helps

topic excluding null values in set analysis in QlikView