Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Valued Contributor III

pie chart showing text

Hi all,

in my pie chart below it is showing " the data set contains zero or negative values"

expression used: =Count({<WeekNumber={$(=vThisWeek)}>}type)

variable:   =vThisWeek=Week(Today())

if I convert  pie to table I didn't see any negative or zero values !

what might b the reason?

Tags (2)
1 Solution

Accepted Solutions
afsarshaikh
Contributor

Re: pie chart showing text

In the Properties pane for the Pie Chart, set the Limitation = Exact Value and use >0

Then uncheck "Show others" checkbox

Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com
7 Replies
arvind_patil
Valued Contributor III

Re: pie chart showing text

Hi Sony,

Kindly provide sample app then we will help you more corrective manner.

Thanks,

Arvind Patil

Partner
Partner

Re: pie chart showing text

Try

if(Count({<WeekNumber={$(=vThisWeek)}>}type))>0,Count({<WeekNumber={$(=vThisWeek)}>}type)

)

afsarshaikh
Contributor

Re: pie chart showing text

In the Properties pane for the Pie Chart, set the Limitation = Exact Value and use >0

Then uncheck "Show others" checkbox

Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com
soniasweety
Valued Contributor III

Re: pie chart showing text

no luck,

its giving the chart is not displayed because it contains only undefined values.

Partner
Partner

Re: pie chart showing text

Can you share sample app?

soniasweety
Valued Contributor III

Re: pie chart showing text

thanks its working fine

Highlighted
frederikjulian
New Contributor

Re: pie chart showing text

Really nice solution, thank you!