topic Re: how to keep static colour background in straight table? in QlikView

how to keep static colour background in straight table?

_rohitgharat — Mon, 20 Jul 2015 05:36:37 GMT

Hii Friends,

I have made a bucket using straight table where i have applied background colour to each bucket.But now when i select on each bucket only selected bucket has a background colour rest of them background colour changes.How can i keep static colour even if i select any bucket? Please help.

See the attached file for reference.

Original Bucket:

After Selection:

Thanks&Regards,

Rohit

Re: how to keep static colour background in straight table?

tresB — Mon, 20 Jul 2015 05:45:57 GMT

You have to use set analysis {1} or so ( {<Field>} , based on your requirement) in the expression that defines your color logic. What is your color defining expression?

Re: how to keep static colour background in straight table?

_rohitgharat — Mon, 20 Jul 2015 05:50:51 GMT

i have taken inline of colours

Colour1,Colour2,Colour3

49,124,89

dimension: bucket

dimension background: rgb(colour1,colour2,colour3)

Re: how to keep static colour background in straight table?

tresB — Mon, 20 Jul 2015 05:54:34 GMT

Try to post a sample : Preparing examples for Upload - Reduction and Data Scrambling

Re: how to keep static colour background in straight table?

jagan — Mon, 20 Jul 2015 07:13:12 GMT

Hi Rohit,

You can do it by using the Custom Format cell. Before that press Ctrl + G and right click on the header cell you can view this option.

My advice is before creating a post prepare some sample data or sample and upload. So that it would be easier to help you, otherwise we need to prepare the sample data, sample chart etc. Sometimes because of this nobody will show interest on your post.

Follow the things in below post.

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.