Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
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

View solution in original post

7 Replies
Highlighted
Partner
Partner

Re: pie chart showing text

Hi Sony,

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

Thanks,

Arvind Patil

Highlighted
Partner
Partner

Re: pie chart showing text

Try

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

)

Highlighted
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

View solution in original post

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

Highlighted
Valued Contributor III

Re: pie chart showing text

thanks its working fine

Highlighted
New Contributor

Re: pie chart showing text

Really nice solution, thank you!