topic Re: issue with pie chart background color in QlikView

issue with pie chart background color

Wed, 25 Nov 2020 16:16:04 GMT

i have written condition like below

if(so_state='Active',Green(),

if(so_state='Cancelled',yellow(),

if(so_state='On Hold',blue(),

if(so_state='Closed',red(),white())))

here i haven't mentioned the black color even though chart showing black color by default like below image .please help out on this.

Thanks

siddu

Re: issue with pie chart background color

sunny_talwar — Tue, 24 May 2016 18:53:16 GMT

The pie chart area that is getting selected at black, is that on-hold section? Can you make sure you have all the casing right for on hold and no dash or anything like that... Also check for white space before or after.

Re: issue with pie chart background color

maxgro — Tue, 24 May 2016 18:54:04 GMT

add a ) at the end

if(so_state='Active',Green(),

if(so_state='Cancelled',yellow(),

if(so_state='On Hold',blue(),

if(so_state='Closed',red(),white()

))))

Re: issue with pie chart background color

agni_gold — Tue, 24 May 2016 18:57:48 GMT

Whatever condition will not full fill , it will take default color , so you can change default color as different or make your condition more.

Re: issue with pie chart background color

Tue, 24 May 2016 18:58:03 GMT

when i am applying

=IF(GetCurrentSelections(state)>0,color(FieldIndex('state',state)),color(FieldIndex('state',state)))

it's works fine but when i am reloading the application the colors of the changing by default

Re: issue with pie chart background color

Tue, 24 May 2016 19:00:37 GMT

yes i.e is on-hold section .i have checked every thing is fine @sunny