topic Re: custom legend in QlikView

custom legend

Wed, 17 Sep 2014 10:56:04 GMT

Hi,

I have to show custom legends, is it possible?

e.g. based on my data I am getting only 2 legends, usually there are other legends in master table. how to show those as well.

Legend1, - data exist and showing in dashboard

Legend2, - data exist and showing in dashboard

Legend3, NO data exist,

Legend4

I have to add Legend3, Legend4 even no data.

Re: custom legend

MK_QSL — Wed, 17 Sep 2014 10:58:17 GMT

Can you please explain little more... quite difficult to understand from this question and explanation...!

Re: custom legend

Wed, 17 Sep 2014 11:06:14 GMT

Hi Manish,

current graph showing some legend values only. I want to show all possible values in the legend even my data table dont those values.

Re: custom legend

Wed, 17 Sep 2014 11:31:26 GMT

Hi All,

ANy help.

Re: custom legend

Wed, 17 Sep 2014 14:19:12 GMT

Hi ALl,

Any updates, Can we have custom legends. I want to add some more legends to existing.

e.g.

for that I want to add 'Not Started' & 'Unknown'.

How do I do it?

Re: custom legend

Wed, 17 Sep 2014 14:19:39 GMT

Hi ALl,

Any updates, Can we have custom legends. I want to add some more legends to existing.

e.g.

for that I want to add 'Not Started' & 'Unknown'.

How do I do it?

Re: custom legend

Wed, 17 Sep 2014 18:29:10 GMT

Attached is what I believe you are tying to do.

Key Features

Load the project status records first, add a dummy field that is just the number 1 to each record for later use
Load a dummy record for each possible status value, with a dummy field value of 0 AND the NOT EXISTS(Status) condition
- This will load a dummy record for only those status values not in your real data
Create a bar graph with your expression as sum(Dummy)
- Color the expression background the RGB values you want for each status value
- Make sure to suppress zero value bars
Create a straight table with status and sum(Dummy)
- Color the expression background the RGB values you want for each status value
- Color the expression text with the same colors as the background if you don't want to see the counts
- Make sure to NOT suppress zero value rows

The color stuff is to guarantee the two objects stay in sync with the colors. Otherwise when you load new data the colors could change. I just would not trust "persistent colors" to work in all cases with mutliple objects.

Re: custom legend

Wed, 17 Sep 2014 18:43:57 GMT

Could you post some sample data??