topic Ranking in a Textbox in QlikView

Ranking in a Textbox

Wed, 21 Jul 2010 14:34:22 GMT

Hello

i curretnly have a chart the Dimension I have used is Opendatemonth, the expression is Count(distinct incidentid). this gives me a count of incidents in each month.

I wish to write a comment below this table stating :

the highest volume of incidents this year were in '....'

Where '...' is the month form the field opendatemonth with the higheest count of incidentids.

Can anyone help please?

Jon

Ranking in a Textbox

shumailh — Wed, 21 Jul 2010 14:41:49 GMT

Hi Jon,

I think you can use the Chart Title for this purpose, if you are not using it. When your chart is active just press [CTRL] + [SHIFT] then you can move/ re-size the sub objects of chart. You can use the chart title for this purpose.

Make sure in your "chart properties---> General Tab--- > Show Title in Chart" should be checked.

Regards,
Shumail Hussain

Ranking in a Textbox

Wed, 21 Jul 2010 14:50:37 GMT

Hello

Sorry i need to do this in a separate text box. And need sto be active (i.e change for diofferent selection criteria0.

jon

Ranking in a Textbox

Thu, 22 Jul 2010 06:25:42 GMT

Hi,

Attached is a workaround solution to your query ...

Ranking in a Textbox

Anonymous — Thu, 22 Jul 2010 07:16:44 GMT

A little add-on to Umang Jain's document. If you change the straight table to a bar chart for example you can add the following expression under Chart Properties > Presentation > Text in chart, to have it as text in the chart:

='Month with highest sales: ' & maxstring(aggr(if(rank(sum(Sale))=1, Month),Month))

Ranking in a Textbox

shumailh — Thu, 22 Jul 2010 07:25:29 GMT

Thanks Johannes, I never tried "Text in chart" before. Gud 1

Best part is this option is very comprehensive we can define the angle, alignment etc.

Regards,
Shumail Hussain

Ranking in a Textbox

Thu, 22 Jul 2010 07:45:03 GMT

Hi Johannes - you taught me something new today thanks ..... 🙂

However a small query ... when I try an use this feature only a part of the text is visible and the remaining stays hidden .... am I missing something here ..

Ranking in a Textbox

Thu, 22 Jul 2010 08:17:15 GMT

Hi Jain,

If i understood your question properly, you can activate your chart by clicking on chart and just press [CTRL] + [SHIFT] then you can move/ re-size the "Text in chart".

- Kevin

Ranking in a Textbox

Thu, 22 Jul 2010 09:13:04 GMT

Thanks Kevin ...