Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to display selected value in a chart

For example you plot a forecast by Quarter, you can select 2  type of business : New or Retention...... What I'm trying to do is to show the 'type of business' value inside the chart

3 Replies
martin59
Valued Contributor II

Re: How to display selected value in a chart

Hi,

You have to use the function GetFieldSelections() like this :

=GetfieldSelections([Type of business])

If you want to show the result in your chart, you can use it in the chart title or with the option "text in chart".

With this option, pay attention to the text position (top left by default), change and resize it with the shortcut  alt+shift.

He that helps you

Martin Favier

Not applicable

Re: How to display selected value in a chart

Hi,

You can try adding this in the chart title:

=if(GetFieldSelections(Type)>0,GetFieldSelections(Type),'All')

Please check the attachment for a sample.

Is that what you are looking for?

Regards,

-Khaled.

Not applicable

Re: How to display selected value in a chart

Many thanks to both for your prompt answer - it is working fine (now need to find a way to expand the size of the text box, but that is another story)

Community Browser