Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Show zeros values in Pie Chart QlikSense

Hello All,

I have a pie chart wherein I show top cities with their minimum count. Some cities have 0 count but they don't get featured in the pie chart. I need to show these cities as well who have 0 count in the pie chart. I have attached a image for reference

Regards

1 Solution

Accepted Solutions
Highlighted
vlad_komarov
Valued Contributor III

Re: Show zeros values in Pie Chart QlikSense

Prateek,

You can use the RangeMax function to "fake" a Zero value and trick the pie chart (with rounding count to the nearest Integer)...

See the attached QFV for details, but you need to add the following to the loading script:

Data:

NoConcatenate Load

district,

RangeMax(0.00000001, count) as count

resident Data_Raw;

Assuming the Data_Raw table contains your original raw data.

And use the num(Sum(count), '##0') as Measure in your Pie-Chart.

It produces the results you need (district FFFF contains 0 counts, but still represented on the chart):

Screen Shot 2017-02-09 at 11.13.18 AM.png

Screen Shot 2017-02-09 at 11.13.48 AM.png

Regards,

Vlad

3 Replies
Highlighted
vlad_komarov
Valued Contributor III

Re: Show zeros values in Pie Chart QlikSense

Prateek,

You can use the RangeMax function to "fake" a Zero value and trick the pie chart (with rounding count to the nearest Integer)...

See the attached QFV for details, but you need to add the following to the loading script:

Data:

NoConcatenate Load

district,

RangeMax(0.00000001, count) as count

resident Data_Raw;

Assuming the Data_Raw table contains your original raw data.

And use the num(Sum(count), '##0') as Measure in your Pie-Chart.

It produces the results you need (district FFFF contains 0 counts, but still represented on the chart):

Screen Shot 2017-02-09 at 11.13.18 AM.png

Screen Shot 2017-02-09 at 11.13.48 AM.png

Regards,

Vlad

Not applicable

Re: Show zeros values in Pie Chart QlikSense

This is great! Thank you Vladimir Kamarov

vlad_komarov
Valued Contributor III

Re: Show zeros values in Pie Chart QlikSense

You are welcome!

VK

Community Browser