topic Help in expression in QlikView

Help in expression

Mon, 27 Feb 2012 06:00:13 GMT

Dear All ,

I have two table one consist of order and other consist of invoice.

I have joined them through left join order to invoice.

I have ten reports where i need only order details but there is one final report which required invoice wise details.

So, there are many orders which are pending fopr invoicing.

Please let me know how to avoid them pivote table.

as i have tried invoice_id<>'' in expression but doesnt work for this.

Plerase help .

Thanks in advance .

Help in expression

jagan — Mon, 27 Feb 2012 06:15:05 GMT

Hi,

I think you want to display only Invoices which has InvoiceID. For this use invoice_id as Dimension and select "Suppress When Value is Null" option in Dimension tab for invoice_id field.

This will suppress all Null values.

Hope this helps you.

Regards,

Jagan.

Re: Help in expression

Mon, 27 Feb 2012 06:59:01 GMT

Thanks a lot jagan

With Regards

Pramod Kumar

Help in expression

jagan — Mon, 27 Feb 2012 07:16:23 GMT

Hi,

Close this discussion by selecting "Correct Answer", if it solves your problem, it helps others to find solution for similar problem.

Regards,

Jagan.