Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
lakshmikandh
Valued Contributor 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

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

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
Esteemed Contributor III

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

Hi,

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

lakshmikandh
Valued Contributor II

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

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

Chanty4u
Esteemed Contributor III

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

Can you your sample Qvf?

lakshmikandh
Valued Contributor II

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

Hi ,

P‌lease check the attached Samples.

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

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

lakshmikandh
Valued Contributor II

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

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

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

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