Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help in expression

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 .

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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.

View solution in original post

3 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

Thanks a lot jagan

With Regards

Pramod Kumar

jagan
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.