topic Re: Title on chart in QlikView

Title on chart

Wed, 24 Apr 2013 20:14:21 GMT

Hi,

I'm sure this will be a simple answer and is rather trivial but on the attched we have a cyclic bar chart. However, half of the title is missing behind the chart. Do you how to show the full title?

Normally put it in the title but as mentioned we are flicking between different questions.

Cheers

Chris

Re: Title on chart

Wed, 24 Apr 2013 20:45:31 GMT

Also can anyone explain on the straight table I have set it to sort by number of reponses in descending order. It works on 3 of the 4 questions but not the last question...

Can anyone help?

Re: Title on chart

MayilVahanan — Wed, 24 Apr 2013 20:55:11 GMT

Use horizontal orientation instead of vertical.

Use Shift and ctrl to align it.

Better use first option

Hope it helps.

Re: Title on chart

Wed, 24 Apr 2013 21:05:46 GMT

Changing to horizontal then effects how the results show wheras shift + ctr allow changes to chart and title but can't move the question text seperately..?

Chris

Re: Title on chart

MayilVahanan — Wed, 24 Apr 2013 21:19:55 GMT

Please check the attached file..

Straight table sorting work as your requirement.

I can't understand ur requirement for the cyclic group. If u change into horizontal orientation, why u need to split the cyclic group?

Hope it helps.

Re: Title on chart

Thu, 25 Apr 2013 06:39:29 GMT

Hi,

Cheers. Is there a character limit witrh the caption?

Regards cyclic group we have five questions and dont want to have to create 5 charts to show the results fro each question. With the cyclic option you can quickly move through each question.

Chris

Re: Title on chart

sujeetsingh — Thu, 25 Apr 2013 08:12:26 GMT

Although you minimise the Graph bars and expand the size of Dimention legend.

Else on caption tab use WRAP TEXT as you need.

Re: Title on chart

Thu, 25 Apr 2013 10:10:36 GMT

try this.

if you wish you can remove the title from the caption and add it in to the title bar.

Re: Title on chart

Thu, 25 Apr 2013 12:14:48 GMT

Thats amazing..thanks.

Can you explain what you did to allow this to work?

Cheers

Re: Title on chart

Thu, 25 Apr 2013 12:24:03 GMT

I am referencing the "Satisfaction" cyclic group by using the GetCurrentField function.

So the expression looks like =GetCurrentField(Satisfaction). I have then added this expression to the Window title.

For the title not to appear next to the cyclic button I have made the font transparent from the Axes tab, so you just see the cycle button.

Re: Title on chart

Thu, 25 Apr 2013 13:24:21 GMT

Hi,

Just notcied while that gets rid of the title you now also lose titles of the bars so you don't know what each bar means....

Chris

Re: Title on chart

Thu, 25 Apr 2013 13:51:28 GMT

Ok, if you go to the dimensions page of the chart and select your "Satisfaction" cyclic group. Under Label <use field name> add some blank spaces.

Then go and undo the transparency of the axes.

See attached for reference.