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: 
satishkurra
Specialist II
Specialist II

Expression help

Hi

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'))))))))

1 Solution

Accepted Solutions
sunny_talwar

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')))))))

or

=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')))))))

View solution in original post

3 Replies
sunny_talwar

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')))))))

or

=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')))))))

satishkurra
Specialist II
Specialist II
Author

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

sunny_talwar

Awesome, thanks for providing the information on which one worked