Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
fahimazizi60
New Contributor

using If condition for showing status of a Region by sales.

I want show the Good,Bad,Fair from by comparing the Region wise sales with the minimum and maximum value in table 1.

i am using this expression  but its not working.

=if(Classification ='Fair' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Fair',
if(Classification ='Bad' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Bad',
if(Classification ='Good' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Good',0)))

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: using If condition for showing status of a Region by sales.

See attached qvw


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: using If condition for showing status of a Region by sales.

See attached qvw


talk is cheap, supply exceeds demand