Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
zagzebski
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
vinieme12
Esteemed Contributor II

Re: Possible value - if statement

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

View solution in original post

1 Reply
Highlighted
vinieme12
Esteemed Contributor II

Re: Possible value - if statement

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

View solution in original post