Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
arethaking
Creator II
Creator II

Customise the legend titles in a bar chart

Hi Guys,

How to customise the legend titles in a bar chart?

Current one:

Capture1.JPG

Required one:

Capture.JPG

Thanks in advance.

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

If you truly need it to look EXACTLY as shown, you could do it with 12 text boxes with the appropriate background color. Then to make absolutely certain your text box colors don't get out of sync with your chart colors, you could define the colors for each month in script, then use set analysis to assign the right color in the text boxes, and a background color for the expression to assign the color in your charts.

You could also use a pivot table with background colors and dimensions quarter and month in quarter.

I'd avoid either approach at almost all costs, but I have had users that insist that something must look EXACTLY like they want, even if what I've given them is completely functionally equivalent.

See attached example. I only set colors for the first three months, and didn't complete the job for the text boxes, but it should be enough to get the idea.

qwgwrfe.PNG

View solution in original post

8 Replies
sunny_talwar

I don't think this is possible with inbuilt functionality of QlikView. the closest you can get is this

Capture.PNG

sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi,

Try this..

MonthNo:

Load * inline [

Month, MonthNo

Jan, 1

Feb, 2

Mar, 3

Apr, 4

May, 5

Jun, 6

Jul, 7

Aug, 8

Sep, 9

Oct, 10

Nov, 11

Dec, 12

];

-Sathish

arethaking
Creator II
Creator II
Author

Sunny T and Sathish G,

How you have achieved this? Please give the steps.

sunny_talwar

I just moved the legend to the bottom of the chart. You can move it by pressing Shift + Ctrl + S and when you see red lines appearing, drag the legend box all the way to the bottom.

sathishkumar_go
Partner - Specialist
Partner - Specialist

Yes.. I have done the same what sunny has mentioned above.

-Sathish

Not applicable

Hi

By using Ctrl+Shift we can drag the legends from up to bottom.

go to the presentation tab and we can change the font and format of legends by using legend setting.

johnw
Champion III
Champion III

If you truly need it to look EXACTLY as shown, you could do it with 12 text boxes with the appropriate background color. Then to make absolutely certain your text box colors don't get out of sync with your chart colors, you could define the colors for each month in script, then use set analysis to assign the right color in the text boxes, and a background color for the expression to assign the color in your charts.

You could also use a pivot table with background colors and dimensions quarter and month in quarter.

I'd avoid either approach at almost all costs, but I have had users that insist that something must look EXACTLY like they want, even if what I've given them is completely functionally equivalent.

See attached example. I only set colors for the first three months, and didn't complete the job for the text boxes, but it should be enough to get the idea.

qwgwrfe.PNG

sunny_talwar

I wish there was a way to group things together in QlikView so those 12 text boxes could have been grouped together into one object.