topic Filter output in pivot chart in QlikView

Filter output in pivot chart

Mon, 27 Jun 2011 11:02:25 GMT

Dear,

I have a pivot chart with dimension 'Invoice_Status' which has value 'Invoice Closed' & 'invoice rejected' and I want to display only 'Invoice closed' data, than how to i do that

Filter output in pivot chart

kaushiknsolanki — Mon, 27 Jun 2011 11:07:13 GMT

Hi,

Try this.

if(Invoice_Status = 'Invoice Closed',Invoice_Status)

Also check the suppress when value is null.

Regards,

Kaushik Solanki