Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
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
afsar_shaikh12
New Contributor III

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

7 Replies
arvind_patil
Valued Contributor II

Re: pie chart showing text

Hi Sony,

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

Thanks,

Arvind Patil

shraddha_g
Honored Contributor III

Re: pie chart showing text

Try

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

)

afsar_shaikh12
New Contributor III

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

soniasweety
Contributor III

Re: pie chart showing text

no luck,

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

shraddha_g
Honored Contributor III

Re: pie chart showing text

Can you share sample app?

soniasweety
Contributor III

Re: pie chart showing text

thanks its working fine

frederikjulian
New Contributor

Re: pie chart showing text

Really nice solution, thank you!