Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

excluding null values in set analysis

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

I can walk on water when it freezes
1 Reply
SunilChauhan
Champion II
Champion II

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

          Emp_name -= {}
       >}
      
Sales$HT
       )

hope this helps

Sunil Chauhan