"+" sign is not showing in the Qlik sense -Pie chart field

[lakshmikandh]

Hi,

I am using Qlik sense Desktop 3.0 ,In excel i have filed called Age group and it has values "<30","30-40","40-50","60 +"

If i make pie chart its showing as

"+" sign is not showing up at the end.

Is there any issue in using "+" in filed at the end ?

[Chanty4u]

Hi,

I am not sure what your expecting?    even check this once

[lakshmikandh]

Just replace the date "over a month" with "30 +" and check i that "+" is showing up in the chart labels

[Chanty4u]

Can you your sample Qvf?

[lakshmikandh]

Hi ,

P‌lease check the attached Samples.

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD

    Text("Age Group") as "Age Group",

    Value

FROM [lib://Lib/testt.xlsx]

(ooxml, embedded labels, table is Sheet1);

[lakshmikandh]

In case i load it from SQL database same function Text () applies ?

[sunny_talwar]

You will have to check the SQL syntax to convert a number into text. Or if the conversion is taking place in Qlik Sense, then you can do Text(FieldName) in the preceding load