# Qlik Sense App Development

Valued Contributor II

## Qlik Sense how to display 49% on the chart title ?

Hi All

I like to save space , any one have alternative solution ?

1 Solution

Accepted Solutions
Honored Contributor III

## Re: Qlik Sense how to display 49% on the chart title ?

Try this -

= 'Sales Vs Target % SOURCE=ADL - ' &

Num(\$(vSaleVsTar2017),'#,##0.0%')

12 Replies
Contributor II

## Re: Qlik Sense how to display 49% on the chart title ?

Hi paulyeo11,

I think you can use the formula for Sales Vs Target % in the Title tab too.

For Eg: You can use 'Sales Vs Target %  - '&(Formula for Sales Vs Target % * 100) & '%'

Regards,

RT

Valued Contributor II

## Re: Qlik Sense how to display 49% on the chart title ?

hI sIR

I have try and unable to make the % appear at the title

Option 1

(

Sum({\$<year = {\$(=Max(year)-0)}, month = {"<=\$(=Max({<year={\$(=Max(year)-0)}, sales = {'*'}>} month))"}>}sales/Rate)

/

Sum({\$<year = {\$(=Max(year)-0)}, month = {"<=\$(=Max({<year={\$(=Max(year)-0)}, sales = {'*'}>} month))"}>}sales_target/Rate)

)-1

Option 2

\$(vSaleVsTar2017)

Paul

Honored Contributor III

## Re: Qlik Sense how to display 49% on the chart title ?

Try this -

= 'Sales Vs Target % SOURCE=ADL - ' &

Num(\$(vSaleVsTar2017),'#,##0.0%')

Honored Contributor III

## Re: Qlik Sense how to display 49% on the chart title ?

Updated one

Valued Contributor II

## Re: Qlik Sense how to display 49% on the chart title ?

Hi Dig

Thank you it work fine now :-

= 'Sales Vs Target % SOURCE=ADL - ' & Num(\$(vSaleVsTar2017),'#,##0.0%')

= 'Sales Vs Target % SOURCE=ADL - '& Num (\$(vSalesVsTar2017) ,'#,##0.0% * 100) & '%'

On my actual application , my SOURCE  have:-

TDSS

TDSKL

TDSPG

May i know how to make it display TDSS when user select TDS instead of ADL now ? As now it display SOURCE=ADL

Paul Yeo

Honored Contributor III

## Re: Qlik Sense how to display 49% on the chart title ?

If its a field, and you have single selection in that, you can use that

field name surrounded by ‘&’ in the same expression and remove hardcoding

Valued Contributor II

## Re: Qlik Sense how to display 49% on the chart title ?

Hi Dig

My enclosed QVF have 2 label for SOURCE field.

now i select source = TDSPG

How to make it display TDSPG at the title ?

PAul

Honored Contributor III

## Re: Qlik Sense how to display 49% on the chart title ?

Like this -

= 'Sales Vs Target % Source = ' & SOURCE & ' - ' &

Num(\$(vSaleVsTar2017),'#,##0.0%')

But if no source is selected, then it will show blank

Valued Contributor II

## Re: Qlik Sense how to display 49% on the chart title ?

Hi Dig

I though need to make use of getfieldname command , I now aware that just use SOURCE will work.

Now i at airport , will look for wifi to test your code .

Thank you

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>