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
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.

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