topic Re: List Box Color Legend using a Linear Gauge? in QlikView

List Box Color Legend using a Linear Gauge?

b_garside — Thu, 04 Jun 2015 19:08:01 GMT

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..

Re: List Box Color Legend using a Linear Gauge?

petter — Thu, 04 Jun 2015 19:53:36 GMT

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

Re: List Box Color Legend using a Linear Gauge?

b_garside — Thu, 04 Jun 2015 19:57:55 GMT

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

Re: List Box Color Legend using a Linear Gauge?

marcus_sommer — Thu, 04 Jun 2015 19:59:53 GMT

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

Re: List Box Color Legend using a Linear Gauge?

b_garside — Thu, 04 Jun 2015 20:07:36 GMT

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.

Re: List Box Color Legend using a Linear Gauge?

marcus_sommer — Thu, 04 Jun 2015 20:12:40 GMT

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

Re: List Box Color Legend using a Linear Gauge?

petter — Thu, 04 Jun 2015 20:22:56 GMT

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:

Re: List Box Color Legend using a Linear Gauge?

b_garside — Thu, 04 Jun 2015 20:23:08 GMT

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."

Re: List Box Color Legend using a Linear Gauge?

b_garside — Thu, 04 Jun 2015 20:28:32 GMT

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!

Re: List Box Color Legend using a Linear Gauge?

petter — Thu, 04 Jun 2015 20:33:42 GMT

You're welcome

Re: List Box Color Legend using a Linear Gauge?

vikasmahajan — Thu, 10 Mar 2016 06:39:35 GMT

Very Nice Petter

Thanks for sharing

Vikas