Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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?

1 Solution

Accepted Solutions
afsarshaikh
Creator
Creator

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
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Sony,

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

Thanks,

Arvind Patil

shraddha_g
Partner - Master III
Partner - Master III

Try

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

)

afsarshaikh
Creator
Creator

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
Master
Master
Author

no luck,

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

shraddha_g
Partner - Master III
Partner - Master III

Can you share sample app?

soniasweety
Master
Master
Author

thanks its working fine

Anonymous
Not applicable

Really nice solution, thank you!