topic Re: Expression help in QlikView

Expression help

satishkurra — Thu, 10 Mar 2016 17:57:53 GMT

The below expression is showing OK. But i'm not able to see a color change for GetSelectedCount(Family) >=1 and Family='Nursing'.

Not sure what is going wrong here.

Can some one help me on the same....

Expression:

=if(GetSelectedCount(Family)<1,

if(Sum(Sales)=0,'autocolor,#d3d3d3',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

if(Sum(Sales) > 300, 'autocolor,#00008B')))))

,if(GetSelectedCount(Family)>=1,

if(Sum(Sales)=0,'autocolor,#00FFFFFF',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

if(Sum(Sales) > 300, 'autocolor,#00008B')))))

,if(GetSelectedCount(Family)>=1 and Family='Nursing',

if(Sum(Sales)=0,'autocolor,#00FFFFFF',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#ff7f7f',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#ff6666',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#ff4c4c',

if(Sum(Sales) > 300, 'autocolor,#ff3232'))))))))

Re: Expression help

sunny_talwar — Thu, 10 Mar 2016 18:01:48 GMT

May be this:

=if(GetSelectedCount(Family)<1,

if(Sum(Sales)=0,'autocolor,#d3d3d3',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

if(Sum(Sales) > 300, 'autocolor,#00008B')))))

,if(GetSelectedCount(Family)=1 and Family='Nursing',

if(Sum(Sales)=0,'autocolor,#00FFFFFF',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#ff7f7f',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#ff6666',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#ff4c4c',

if(Sum(Sales) > 300, 'autocolor,#ff3232'))))))

,if(GetSelectedCount(Family)>=1,

if(Sum(Sales)=0,'autocolor,#00FFFFFF',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

if(Sum(Sales) > 300, 'autocolor,#00008B')))))))

=if(GetSelectedCount(Family)<1,

if(Sum(Sales)=0,'autocolor,#d3d3d3',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

if(Sum(Sales) > 300, 'autocolor,#00008B')))))

,if(GetSelectedCount(Family)>=1 and SubStringCount(Concat(DISTINCT Family, '|'), 'Nursing') = 1,

if(Sum(Sales)=0,'autocolor,#00FFFFFF',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#ff7f7f',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#ff6666',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#ff4c4c',

if(Sum(Sales) > 300, 'autocolor,#ff3232'))))))

,if(GetSelectedCount(Family)>=1,

if(Sum(Sales)=0,'autocolor,#00FFFFFF',

if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

if(Sum(Sales) > 300, 'autocolor,#00008B')))))))

Re: Expression help

satishkurra — Thu, 10 Mar 2016 18:09:53 GMT

First one worked and i didn't try the 2nd one

Re: Expression help

sunny_talwar — Thu, 10 Mar 2016 18:10:39 GMT

Awesome, thanks for providing the information on which one worked