topic Re: How to show the legend in horizontal Row in QlikView

How to show the legend in horizontal Row

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

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

I Tried Control Shift option also

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

But I want like this only

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

Thank you in advance

Re: How to show the legend in horizontal Row

agastya — Fri, 10 Aug 2018 10:01:16 GMT

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]

Re: How to show the legend in horizontal Row

agastya — Fri, 10 Aug 2018 10:10:09 GMT

OR SOMETHING LIKE THIS

Re: How to show the legend in horizontal Row

stabben23 — Fri, 10 Aug 2018 10:27:59 GMT

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.

Re: How to show the legend in horizontal Row

raman_rastogi — Fri, 10 Aug 2018 10:51:12 GMT

Hi,

Try This

First Reset User Docking

Properties-> General->Reset User Docking

Press Ctrl+Shift and drag and drop your legend.

Raman

Re: How to show the legend in horizontal Row

bvssudhakar — Fri, 10 Aug 2018 10:51:41 GMT

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])

Re: How to show the legend in horizontal Row

bvssudhakar — Fri, 10 Aug 2018 10:54:19 GMT

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

Re: How to show the legend in horizontal Row

bvssudhakar — Fri, 10 Aug 2018 10:54:43 GMT

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

Re: How to show the legend in horizontal Row

agastya — Fri, 10 Aug 2018 11:11:23 GMT

could you please share Qvf file with us.

Re: How to show the legend in horizontal Row

manoj217 — Fri, 10 Aug 2018 11:15:32 GMT

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

Re: How to show the legend in horizontal Row

raman_rastogi — Fri, 10 Aug 2018 11:22:34 GMT

Hi Sudhakar,

I think we can not change legend position through expression.

For More Details See Link Below.

Horizontal Legend in chart

Best

Raman

Re: How to show the legend in horizontal Row

stabben23 — Fri, 10 Aug 2018 11:36:45 GMT

as manoj say, the Box will get much wider, from side to side in chart. After that decrease the size of the red Box by draging it from bottom. This is a little bit tricky so have patience.

Re: How to show the legend in horizontal Row

manoj217 — Fri, 10 Aug 2018 11:36:46 GMT

Your second requirement do you want to show the values as well as expression right?

like .net 50

power bi 75

consulting 80

if in this manner means its not possible but there is away.

you can concatenate the values with expression then call it as dimension in pie chart and dont show the values on data points.

it will work for this requirement

Re: How to show the legend in horizontal Row

stabben23 — Fri, 10 Aug 2018 11:56:37 GMT

This is not working for me in a pie chart the same way as in a barchart, dont know why.

Re: How to show the legend in horizontal Row

manoj217 — Fri, 10 Aug 2018 12:03:27 GMT

rearrange the size of bar chart.the red box will not overlap on each other first resize the chart then drag the legend at bottom then the box will become wider

Re: How to show the legend in horizontal Row

bvssudhakar — Fri, 10 Aug 2018 13:21:49 GMT

I made whatever you suggested but here i am getting one more problem all charts are attaching i want gap between dimension names if i change in Bar settings under presentation tab then all bars are separating and giving confusion to users

I want some big gap between 5 charts after and 5 charts after

Re: How to show the legend in horizontal Row

manoj217 — Fri, 10 Aug 2018 13:32:25 GMT

Re: How to show the legend in horizontal Row

stabben23 — Fri, 10 Aug 2018 13:42:06 GMT

try to increase Cluster Distance in presetation tab