Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
b_garside
Partner - Specialist
Partner - Specialist

List Box Color Legend using a Linear Gauge?

I was playing around with the idea of creating a color legend built from a Linear Gauge with no color segments or at least a solid color that matches each distinct value.

If I had Product A, Product CC, Product H, Product D

Here is a simple mock-up where it only shows the default Green, but it should show a unique color for each value.

My search did not return any similar attempts like this..

Capture.PNG

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

I am not able to achieve it within a single listbox. But having a list box side-by-side with a simplified straight table I am able to achieve this:

2015-06-04 #1.PNG

View solution in original post

10 Replies
petter
Partner - Champion III
Partner - Champion III

Sorry ... I don't really get what you are asking about?

b_garside
Partner - Specialist
Partner - Specialist
Author

I need a calculated color for the linear bar to dynamically change with the values in the list box.

It can be any value 1,2,3,4  vs Product.

I currently am using a Pick(Num(Product),Green(),Red(),Blue() )  etc... but it wont work.

Hope this make more sense...Thanks for the reply

marcus_sommer

You could use a table-chart instead of a listbox. This example isn't excactly what do you want to do but I think it will give you a hint and I believe you will find here various postings if searched on it:

Building a nicer, dynamic QlikView multibox The Qlik Fix!

- Marcus

b_garside
Partner - Specialist
Partner - Specialist
Author

Ok, Thanks for this may use that later on. It just does not fit what I want to do.

I'm trying to do a silent legend by using the colors from a linear gauge or something akin to it. 

This is from a need to disable the legend in the adjacent chart.

The expression would hopefully allow it to change based on the defined values within the list box.

marcus_sommer

I have already build outside chart-legends with table-charts - therefore I know it's possible. Maybe you get here more hints: Use of a Silent Legend

- Marcus

petter
Partner - Champion III
Partner - Champion III

I am not able to achieve it within a single listbox. But having a list box side-by-side with a simplified straight table I am able to achieve this:

2015-06-04 #1.PNG

b_garside
Partner - Specialist
Partner - Specialist
Author

Thanks Marcus It looks like some good examples. I will dig up the demo . The Tech brief states they used a bunch of text boxes.  I will keep trying until I can arrive at more manageable solution.

Tech Brief states;

"Since the expression legends in the two charts are repetitive, a new approach was taken and a

new legend was created. To do this, Text Objects were added to the right of the Company List

Box as a silent legend that can be used with all the visualizations on the sheet. The legend was

also carried over to the pivot table at the top of the sheet to further provide information for the

user."

b_garside
Partner - Specialist
Partner - Specialist
Author

Petter, 

You captured my vision here. So it seems this will work.

A Straight table and list box placed together. Down to two objects. vs multiple.

The straight table I used prior was slow since it used real data vs. a Value list which should load quicker

Thanks!

petter
Partner - Champion III
Partner - Champion III

You're welcome