Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

RE:Exact colur

Hi all,

I have some issue on colur coding.  below is my code for  colurs

  count(if(Prod_Severity = '1-Critical' or Prod_Severity = '2-Major',Prod_Defect_ID))

  ) * 100 < 95, rgb(255,0,0),

but am getting   for  100%   its shwng  amber  without any selections.

and if i do any selection that value is 100%  and colur shwng as green?

how come  is there any issue in the exp?

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted

Missed the if statement

If(Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

If(Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

View solution in original post

14 Replies
Highlighted

1st of all, I would suggest you change the if statements to set analysis. I still don't know what might be causing it, but changing to set analysis will clear out some clutter here:

Count({<Prod_Severity = {'1-Critical', '2-Major'} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

Count({<Prod_Severity = {'1-Critical', '2-Major'} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Highlighted
Champion III
Champion III

shwng expression error sunny.

Highlighted

Sorry, I missed the missing set analysis syntax:

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Highlighted
Champion III
Champion III

Hmmm..Still it is shwng error in expression?

Highlighted

Missed the if statement

If(Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

If(Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

View solution in original post

Highlighted
Champion III
Champion III

still same issue.........sunny

Highlighted

Really? that is embarrassing? Your original expression worked as you would expect without errors?

Highlighted
Creator III
Creator III

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Highlighted
Champion III
Champion III

original exp wrkng fyn but the colurs not givng exctly...