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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Pragya
Creator
Creator

Multiple If condtions with aggregate function - error

Hi There ,

I am trying to put two-three conditions in if statement and facing error.

So If I write

 SUM(if ([Arrival Year] <> 2020, Area_Resident))  / Sum(Population) *100000 ( works fine)

when I write

 SUM(if ([Arrival Year] <> 2020 and [Arrival Month] <> {'July'}, Area_Resident))  / Sum(Population) *100000 , I get error.

Could anyone suggest please ?

My aim is to use 2-3 conditions  in expression editor for one of the graph please

 

 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Pragya  try below set analysis

 SUM({<[Arrival Year] -={'2020'} , [Arrival Month] -={'July'}>}Area_Resident))  / Sum(Population)*100000

View solution in original post

1 Reply
Kushal_Chawda

@Pragya  try below set analysis

 SUM({<[Arrival Year] -={'2020'} , [Arrival Month] -={'July'}>}Area_Resident))  / Sum(Population)*100000