Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

cliff_clayman
New Contributor III

Creating a Pie Chart from Straight Table

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.

POs.JPG

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')

23 Replies
MVP
MVP

Re: Creating a Pie Chart from Straight Table

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?

cliff_clayman
New Contributor III

Re: Creating a Pie Chart from Straight Table

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.

MVP
MVP

Re: Creating a Pie Chart from Straight Table

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

cliff_clayman
New Contributor III

Re: Creating a Pie Chart from Straight Table

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?

MVP
MVP

Re: Creating a Pie Chart from Straight Table

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'}>}

cliff_clayman
New Contributor III

Re: Creating a Pie Chart from Straight Table

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

MVP
MVP

Re: Creating a Pie Chart from Straight Table

Can you share how your raw data looks like?

cliff_clayman
New Contributor III

Re: Creating a Pie Chart from Straight Table

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.

MVP
MVP

Re: Creating a Pie Chart from Straight Table

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