Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bvssudhakar
Contributor

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
vishalpujari22
New Contributor III

Re: How to show the legend in horizontal Row

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

vishalpujari22
New Contributor III

Re: How to show the legend in horizontal Row

OR SOMETHING LIKE THIS Pie chart.PNG

stabben23
Honored Contributor

Re: How to show the legend in horizontal Row

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
Contributor II

Re: How to show the legend in horizontal Row

Hi,

Try This

First Reset User Docking

Properties-> General->Reset User Docking

Press Ctrl+Shift and drag and drop your legend.


Raman

bvssudhakar
Contributor

Re: How to show the legend in horizontal Row

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
Contributor

Re: How to show the legend in horizontal Row

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
Contributor

Re: How to show the legend in horizontal Row

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

vishalpujari22
New Contributor III

Re: How to show the legend in horizontal Row

could you please share Qvf file with us.

manoj217
Contributor II

Re: How to show the legend in horizontal Row

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

Community Browser