Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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:
Sorry ... I don't really get what you are asking about?
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
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
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.
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
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:
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."
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!
You're welcome