topic Block Chart set colour based on Demension in QlikView

Block Chart set colour based on Demension

Tue, 23 Aug 2011 12:30:22 GMT

Hi guys

I have a Block chart based on activity, each activity has a category, for example see below

Activity Category

Margin Financial

Rate Financial

Cert Documentation

Mail Other

The demensions of the block chart is Activity and Category, but I wish to set the colours based on the categories, so all Financial ( either margin or Rate) will be green , all Documentation blue and so on,

Is this possible ? Can anyone help me please ?

Thanks

Block Chart set colour based on Demension

its_anandrjs — Tue, 23 Aug 2011 12:38:00 GMT

Hi,

Yes you can achieve this by set the RGB color for the category and use it ase the base colors.

Regards,

Anand

Re: Block Chart set colour based on Demension

its_anandrjs — Tue, 23 Aug 2011 12:45:58 GMT

Hi,

You need to set some color code in the Colors property of the chart and set base colors try to put this code =if(Category='Financial',Green(),Green()) and see the result.

Regards,

Anand

Re: Block Chart set colour based on Demension

its_anandrjs — Tue, 23 Aug 2011 12:50:01 GMT

Hi,

Put this three codes for color setting in Colors properties.

=if(Category='Financial',Green(),Green())

=if(Category='Documentation',Red(),Red())

=if(Category='Other',Yellow(),Yellow())

For the three categories put this three codes and set Persistent colors check mark.

Regards,

Anand

Block Chart set colour based on Demension

Tue, 23 Aug 2011 13:01:59 GMT

Hi Guys,

I have a code written and I have put it in the demensions tab, Background colour , I have tick persistant colours but it does not seem to work ,

the following is the code - I have tried it on the demensions tab under both demensions - perhaps there is an error - please help

Thanks

=if(Structural='Financial', RGB(0,127,0),

if(Structural='Statics' , RGB (255,128,0),

if(Structural='Arrears' , RGB (255,0,0),

if(Structural= 'Documentation',RGB(255,50,50),

if(Structural= 'General', RGB ( 0,57,01),

if(Structural= 'Mails',RGB(200,127,00),

if(Structural = 'Reports',RGB(255,127,0),

RGB(255,255,255))))))))

Re: Block Chart set colour based on Demension

its_anandrjs — Tue, 23 Aug 2011 13:04:36 GMT

Hi,

See the attached sample for clearilty i put this three codes for color definition

=if(Category='Financial',Green(),Green())

=if(Category='Documentation',Red(),Red())

=if(Category='Other',Yellow(),Yellow())

for three categories which are available.

Regards,

Anand

Re: Block Chart set colour based on Demension

john_duffy — Tue, 23 Aug 2011 13:13:05 GMT

Hello.

Another option would be to use your If statement to set the expressions background colour.

See the attached example.

John.

Block Chart set colour based on Demension

Tue, 23 Aug 2011 13:19:38 GMT

Perfect guys

Both solutions work as I wish,

many thanks