Creating a Pie Chart from Straight Table

[cliff_clayman]

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

[cliff_clayman]

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

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

[Anil_Babu_Samineni]

Can you share sample application as Talwar asked

QlikCommunity Tip: How to get answers to your post?

[sunny_talwar]

May be a set analysis like this:

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

[cliff_clayman]

Where do I put this?

[sunny_talwar]

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

[cliff_clayman]

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

[sunny_talwar]

What is your expression?

[cliff_clayman]

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

[Anil_Babu_Samineni]

Might be sunny suggestion is this?

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

[sunny_talwar]

Anil -

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