Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bharatkishore
Contributor 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
Contributor III

Re: Block Chart Colors

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

View solution in original post

7 Replies
Chanty4u
Esteemed Contributor III

Re: Block Chart Colors

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
Contributor III

Re: Block Chart Colors

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

Chanty4u
Esteemed Contributor III

Re: Block Chart Colors

try

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

Re: Block Chart Colors

Hi Bharat,

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

Capture.JPG

bharatkishore
Contributor III

Re: Block Chart Colors

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

View solution in original post

bharatkishore
Contributor III

Re: Block Chart Colors

Thanks Chanty.. Found the answer..

Chanty4u
Esteemed Contributor III

Re: Block Chart Colors

cool   how u did u done this?