Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmikandh
Specialist II
Specialist II

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

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

pie chart issue.png

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

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Table:

LOAD

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

    Value

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

(ooxml, embedded labels, table is Sheet1);


Capture.PNG

View solution in original post

7 Replies
Chanty4u
MVP
MVP

Hi,

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

lakshmikandh
Specialist II
Specialist II
Author

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

Chanty4u
MVP
MVP

Can you your sample Qvf?

lakshmikandh
Specialist II
Specialist II
Author

Hi ,

P‌lease check the attached Samples.

sunny_talwar

Try this:

Table:

LOAD

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

    Value

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

(ooxml, embedded labels, table is Sheet1);


Capture.PNG

lakshmikandh
Specialist II
Specialist II
Author

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