Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Possible value - if statement

I need to write an if statement to get a possible value. When a salesman is selected I need to return a 1 if specific region is possible and 0 if not possible.

For example...if salesman John Smith is selected return a one (1)  if it is possible that he had sales in the "East" region and a zero (0) if it is not possible that John Smith had sales in the "East" region.

Thanks,

Zag

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

if(sum({<Region={'East'}>}Sales)>0,1,0)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

if(sum({<Region={'East'}>}Sales)>0,1,0)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.