topic Re: Block Chart Colors in QlikView

Block Chart Colors

bharatkishore — Thu, 17 Mar 2016 10:34:36 GMT

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:

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

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

Re: Block Chart Colors

Chanty4u — Thu, 17 Mar 2016 10:39:22 GMT

u can use indicator

=if

(

Sum(

if(

Status = 'green',1

)

) > 0

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

(

Sum(

if(

Status = 'grey',1

)

) > 0

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

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

)

Re: Block Chart Colors

bharatkishore — Thu, 17 Mar 2016 10:45:41 GMT

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

Re: Block Chart Colors

Chanty4u — Thu, 17 Mar 2016 11:14:59 GMT

try

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

Re: Block Chart Colors

settu_periasamy — Thu, 17 Mar 2016 11:31:11 GMT

Hi Bharat,

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

Re: Block Chart Colors

bharatkishore — Thu, 17 Mar 2016 11:48:43 GMT

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

Re: Block Chart Colors

bharatkishore — Thu, 17 Mar 2016 11:49:10 GMT

Thanks Chanty.. Found the answer..

Re: Block Chart Colors

Chanty4u — Thu, 17 Mar 2016 11:50:02 GMT

cool how u did u done this?