Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Highlighted

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.

Highlighted

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