Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

how to keep static colour background in straight table?

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:

bucket1.PNG

After Selection:

bucket3.PNG

Thanks&Regards,

Rohit

4 Replies
MVP
MVP

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?

Contributor III
Contributor III

i have taken inline of colours

Colour1,Colour2,Colour3

49,124,89

dimension: bucket

dimension background: rgb(colour1,colour2,colour3)

MVP
MVP

MVP & Luminary
MVP & Luminary

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.