topic Creating a Pie Chart from Straight Table in QlikView

Creating a Pie Chart from Straight Table

cliff_clayman — Tue, 06 Sep 2016 21:37:14 GMT

I would like to create a Pie Chart from some data I prepared in a Straight Table. However, I would only like to chart a portion of the data.

I only want to chart the ratio between the values on the PO row. How can I limit the data in this straight table and turn it into a Pie Chart? I had to create a calculated Dimension for the Po vs No PO field.

=If(Len([PO]) = 0,'No PO','PO')

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Tue, 06 Sep 2016 21:42:30 GMT

What exactly is your expression that you are trying to plot here? What is PO vs No PO field here? Is this a calculated dimension as well?

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Tue, 06 Sep 2016 21:44:34 GMT

I am trying to plot the data in the PO row. The number of Invoices in comparison to the number of POs. Yes, the PO vs No PO field is a calculated dimension.

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Tue, 06 Sep 2016 21:46:20 GMT

I guess what is the issue you are running into here? You are using a single expression or multiple expressions? Would you be able to provide a sample

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Tue, 06 Sep 2016 21:52:41 GMT

I only want to be able to plot one set of the data. How do I limit the data to just plot the PO data in the Pie Chart?

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Tue, 06 Sep 2016 21:57:00 GMT

You can use set analysis for that, but if PO vs No PO is not a field, what is the field that can be used to determine if the row is PO data or not? Assuming PO vs No PO was a field, you could have done this...

{<[PO vs No PO] = {'PO'}>}

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Tue, 06 Sep 2016 22:55:52 GMT

‌No, it is not a field, it is a calculated dimension.

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Tue, 06 Sep 2016 22:57:00 GMT

Can you share how your raw data looks like?

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Wed, 07 Sep 2016 14:33:24 GMT

It looks just like what I posted. FY is a field. I do a Count DISTINCT on POs and a SUM for Invoices. PO vs No PO is a calculated dimension that I posted earlier.

Sometimes we have an Invoice without a PO and I am trying to show the ratio of the occurrences when we do have a PO with an Invoice.

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Wed, 07 Sep 2016 14:44:15 GMT

But you have been telling me that PO vs No PO is a calculated dimension, right? How do you create it? I just don't know how you differentiate between PO and No PO

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Wed, 07 Sep 2016 14:45:29 GMT

=If(Len([PO]) = 0,'No PO','PO')

That is how. If the PO field is blank or essentially = 0, then there is No PO.

Re: Creating a Pie Chart from Straight Table

Anil_Babu_Samineni — Wed, 07 Sep 2016 15:05:08 GMT

Can you share sample application as Talwar asked

QlikCommunity Tip: How to get answers to your post?

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Wed, 07 Sep 2016 15:08:06 GMT

May be a set analysis like this:

{<[PO] = {"=Len(Trim(PO)) > 0"}>}

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Wed, 07 Sep 2016 15:09:58 GMT

Where do I put this?

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Wed, 07 Sep 2016 15:11:50 GMT

In your expression so that you only get the PO line.

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Wed, 07 Sep 2016 15:15:28 GMT

Something is wrong with the syntax...Garbage after expression: '='

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Wed, 07 Sep 2016 15:17:27 GMT

What is your expression?

Re: Creating a Pie Chart from Straight Table

cliff_clayman — Wed, 07 Sep 2016 15:20:24 GMT

I just used the Set Analysis you provided. Is it to be added to an existing expression? Here is my expression for PO:

=Count(DISTINCT [PO])

Re: Creating a Pie Chart from Straight Table

Anil_Babu_Samineni — Wed, 07 Sep 2016 15:36:35 GMT

Might be sunny suggestion is this?

Count( {<[PO] = {"=Len(Trim(PO)) > 0"}>} <Target-Value>)Re: Creating a Pie Chart from Straight Table

Re: Creating a Pie Chart from Straight Table

sunny_talwar — Wed, 07 Sep 2016 16:50:31 GMT

Anil -

This -> =Count(DISTINCT {<[PO] = {"=Len(Trim(PO)) > 0"}>} [PO])