Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Block Chart Colors

Hi All,

I have a multi box where i have some fields(filters))(say for example 1,2,3,4,5) in it.

I have created a block chart as you see in the below image:

Chart.PNG

Now when i click a a fields in multibox the heat map colors changes as you can see in the below image:

Chart1.PNG

Expression written in the background color is :

IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 11+12+13+14, Green(),

IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 15, LightGray(),

IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 16, RGB(255,128,0),

IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 17, RGB(255,128,96),

IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 18, RGB(255,0,0),

IF([Ageing Buckets(Due in)] = 'Current - Due in >15 days', RGB(0,255,0),

IF([Ageing Buckets(Due in)] = 'Current - Due in 10 to 15 days', RGB(0,220,0),

IF([Ageing Buckets(Due in)] = 'Current - Due in 5 to 10 days', RGB(0,192,0),

IF([Ageing Buckets(Due in)] = 'Current - Due in <5 days', RGB(0,128,0),

White()

)))))))))

Now my requirement is even if i select any filter in the multi box the current color should come as "green" and "1-30 as grey". It shouldnot change to white.

Can you please tell me how to achieve this.

Thanks,

Bharat

1 Solution

Accepted Solutions
bharatkishore
Creator III
Creator III
Author

Yes. Settu.. It is checked.. I have found the solution.. Thanks a lot...

View solution in original post

7 Replies
Chanty4u
MVP
MVP

u can use indicator

=if

(

  Sum(

  if(

  Status = 'green',1

   )

  ) > 0

  ,

  'qmem://<bundled>/BuiltIn/led_r.png'

  ,

  if

  (

  Sum(

  if(

Status = 'grey',1

    )

  ) > 0

  ,

  'qmem://<bundled>/BuiltIn/led_y.png'

  ,

  'qmem://<bundled>/BuiltIn/led_g.png')

)

bharatkishore
Creator III
Creator III
Author

Thanks Chanty for the reply. .But i need with the expression which i have written in the background color expression...

Chanty4u
MVP
MVP

try

if(getcurrentselection(filter) >1,green(),lightgray())

settu_periasamy
Master III
Master III

Hi Bharat,

Did you try to check the 'Persistent Colors' option in the Colors Tab?

Capture.JPG

bharatkishore
Creator III
Creator III
Author

Yes. Settu.. It is checked.. I have found the solution.. Thanks a lot...

bharatkishore
Creator III
Creator III
Author

Thanks Chanty.. Found the answer..

Chanty4u
MVP
MVP

cool   how u did u done this?