Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

count lines in pie chart

I want to present a pie chart that counts the part with no inventory (calcultaed field)

tried to put that calculated field as dimentsion and in the exprasion count(part)

but I recieve worng numbers

thanks Esti

3 Replies
Not applicable

Re: count lines in pie chart

Can you share the application or sample data?

MVP
MVP

Re: count lines in pie chart

HI,

Try like this

Dimension : Part

Expression : Count({<Inventory={'>0'}>} Part)

Hope this helps you, if not attach some sample data.

Regards,

Jagan.

Employee
Employee

Re: count lines in pie chart

Hi E F -

When using Sense, you can define calculated fields that return numbers as Measures, not Dimensions.

After creating the expression as a Measure - you can use it in the chart object.

Please let us know if this helps.

8-19-2014 7-29-49 AM.png

8-19-2014 7-26-59 AM.png

8-19-2014 7-28-38 AM.png

8-19-2014 7-29-01 AM.png

HTH

Mike