topic Re: Pie Chart expression to show 2 values in QlikView

Pie Chart expression to show 2 values

cliff_clayman — Wed, 24 Aug 2016 14:44:45 GMT

I am trying to create a Pie Chart to show me the count of ID's that exceed limits and then the remainder that are within the limits. Here is the expression to get the Count for the ID's that exceed the limits:

=Count(If([MLimit] > 5000 Or [TLimit] > 2500, [TransID]))

How can I also get the remainder that are within the limits to display on the pie chart?

Re: Pie Chart expression to show 2 values

agomes1971 — Wed, 24 Aug 2016 14:49:17 GMT

Hi,

please send sample.

Thanks

André Gomes

Re: Pie Chart expression to show 2 values

sunny_talwar — Wed, 24 Aug 2016 14:50:11 GMT

May be this as your second expression:

=Count(If([MLimit] <= 5000 and [TLimit] <= 2500, [TransID]))

Re: Pie Chart expression to show 2 values

agomes1971 — Wed, 24 Aug 2016 14:59:03 GMT

Hi,

please see this article:

Pie Charts: Showing Percentage of Two Values

HTH

André Gomes

Re: Pie Chart expression to show 2 values

cliff_clayman — Wed, 24 Aug 2016 15:04:08 GMT

Here is a sample.

Re: Pie Chart expression to show 2 values

sunny_talwar — Wed, 24 Aug 2016 15:09:30 GMT

This?

Re: Pie Chart expression to show 2 values

sunny_talwar — Wed, 24 Aug 2016 15:12:45 GMT

Here I have added two approaches you can use to reach your final goal

Re: Pie Chart expression to show 2 values

Thu, 15 Dec 2016 10:16:48 GMT

Hi Cliff,

I have used two expression.

first expression is used to select all satisfied criteria and second is used to select the opposite of the first thats means you will get all values in our pie chart.

@cliff.clayman @stalwar1

Thanks,