topic Re: RE:Label posiion? in QlikView

RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 06:02:51 GMT

hi all,

is there anyway to change the postion of the cyclic or dril down?

and how to do custom sort order?

PFA image

Thanks in advance...

Re: RE:Label posiion?

ahmar811 — Fri, 11 Dec 2015 06:09:03 GMT

can you please attach sample .qvw file ???

Re: RE:Label posiion?

its_anandrjs — Fri, 11 Dec 2015 06:09:06 GMT

While working on the qlikview click on the chart and press simultaneously CTRL + SHIFT key then you see red lines then by mouse adjust your position.

Regards

Anand

Re: RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 06:10:45 GMT

in my chart when i clik Cntrl+Shift.... that cyclic label is nt shwng to move

Re: RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 06:15:04 GMT

anand...chk my image when i use cntr+shf

Re: RE:Label posiion?

its_anandrjs — Fri, 11 Dec 2015 06:18:00 GMT

Check chart properties and settings it have to be changed.

Re: RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 06:28:15 GMT

but.. i didnt found any settings regarding dis..can u suggest wh option need to chk

Re: RE:Label posiion?

ahmar811 — Fri, 11 Dec 2015 06:29:04 GMT

It's not possible move the label but even if you want to move you should apply the solution given by Anand Chouhan.

I have attach the link below hope this might help you

Re: Moving label of Cyclic Group in bar chart

Regards

Ahmar

Re: RE:Label posiion?

jonathandienst — Fri, 11 Dec 2015 06:40:42 GMT

This is what I have done to solve this problem

Create a dummy chart with the cyclic as a dimension and 1 as the expression
Set the chart background to transparent
Resize the chart down to a suitable size to display only the cyclic and use Ctrl-Shift to move/size the the chart elements that you can control in such a way that the cyclic is displayed approximately in the middle of the reduced chart and the chart is moved to a corner of the sheet object or reduced to a point. You may need some trial and error to get this right. Now the cyclic is the only element of the chart displayed
Now position the dummy chart where you would like the cyclic.

Re: RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 06:49:32 GMT

could u post sample qvw for that.......i didnt get exact

Re: RE:Label posiion?

its_anandrjs — Fri, 11 Dec 2015 07:27:24 GMT

Take the clone copy of this chart to another sheet and check the chart alignments.

Re: RE:Label posiion?

its_anandrjs — Fri, 11 Dec 2015 07:38:29 GMT

You can use trick here as Jonathan suggest for labels only

1. On the original hide the label means not given label but on the top of the chart use label that you want use it as text object and place on top of the chart where you want that.

2. Make the visible property of this object as top so it is visible first.

This trick works but not good idea.

Regards

Anand

Re: RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 07:58:53 GMT

but grouping is nt psble ryt...wen we use text object

Re: RE:Label posiion?

its_anandrjs — Fri, 11 Dec 2015 08:54:59 GMT

You can use AGGR function for that in the text objects.

Regards

Anand

Re: RE:Label posiion?

Chanty4u — Fri, 11 Dec 2015 09:14:35 GMT

THNX ANAND... I HVE DONE CHNGED SOME CHART SETTINGS and x axis and y axis values....so it become somewat better .......