Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
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

Highlighted
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

Highlighted
Chanty4u
Esteemed Contributor III

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

Can you your sample Qvf?

Highlighted
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

Highlighted
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 ?

Highlighted

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