Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

How to show the legend in horizontal Row

Hello Experts,

I want to show my Legend in horizontal row i tried but it is not showing..... It is showing in vertical single.

I want it in like second picture

Capture.JPG

I Tried Control Shift option also

And How to show our data labels names with values in pie chart. Actually what i created is thisCapture1.JPG

But I want like this only

Capture2.JPG

If it is possible can you guys please suggest me how to do

Thank you in advance

17 Replies
agastya
Creator
Creator

hi shudhkar

1]Add dimension ->Skill

2]First expression->sum(Score)[Enable Value on data points]

3]second expression->Skill  [Enable Value on data points]

Pie chart.PNG

agastya
Creator
Creator

OR SOMETHING LIKE THIS Pie chart.PNG

stabben23
Master
Master

Hi,

first, ctrl+shift, drag Your legend over the chart, drop, then decrease the vertical size still hold ctrl+shift, it will then create a horizontal legend.

raman_rastogi
Partner
Partner

Hi,

Try This

First Reset User Docking

Properties-> General->Reset User Docking

Press Ctrl+Shift and drag and drop your legend.


Raman

bvssudhakar
Creator III
Creator III
Author

Hi Vishal,

These two are my expressions, Can you suggest me how to modify those expressions

I tried but it is showing empty. and i want to show whatever u showed in your 1st image...... example Qlikview-60

=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Total No. of Openings])

=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Ageing in days])

bvssudhakar
Creator III
Creator III
Author

Hi Staffan,

I tried but it's not changing..... Is there any possibility to write expression to show the legend as horizontal

And can you also give your suggestions for that pie chart requirement also

Thank you in advance

bvssudhakar
Creator III
Creator III
Author

Hi Raman,

I tried but it's not changing..... Is there any possibility to write expression to show the legend as horizontal

And can you also give your suggestions for that pie chart requirement also

Thank you in advance

agastya
Creator
Creator

could you please share Qvf file with us.

manoj217
Creator III
Creator III

Select the chart object by clicking on the caption. Then press <ctrl>-<shift> and hold. You will see a number of red boxes on the chart. Grab the one around the legend and move all the way to the top or bottom of the object. You should see the box change from vertical to horizontal (i.e. it will get much wider). When it does this, let go of the mouse.

shift + ctrl

using red line:

- expands (horizontal)

- decrease (vertical)

- drag to bottom