12 Replies Latest reply: Feb 8, 2018 8:26 PM by Digvijay Singh

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

Hi All

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

• ###### 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

• ###### 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

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

Try this -

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

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

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

Updated one

• ###### 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

• ###### 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

• ###### 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

• ###### 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

• ###### 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>

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

This will make it perfect -

= 'Sales Vs Target % '&if(GetSelectedCount(SOURCE)= 1, 'Source = ' & SOURCE & ' : ',' : ')  &

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

This will show source only when one of them is selected, if more than one source selected, it will not show.

Even we can show multiple sources here. Let me know if you need that as well.

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

Hi Dig

Thank you very much , this is what I expected , as I need to view the overall target achievement., I owe you one beer.

Paul

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

Ha ha, In community, beer is equivalent to points. I think you awarded enough so I am good.