topic Re: Problem with grouping lines in table in QlikView

Problem with grouping lines in table

Thu, 13 Nov 2014 11:02:51 GMT

Hello,

I have issue with table object, my tables are related as follows in attached file and the problem is:

When I have Name(CustomerName), SalesId(Or InvoiceId) and CustInvoiceTrans.LineAmount column "CustInvoiceTrans.LineAmount" is showing values correctly, but I need that value to be summed after grouping by name(CustomerName) - I just remove salesId(or InvoiceId) column from table and my table become empty instead of showing summed lineAmount by Name.

Any suggestions?

Thank You in advance!

Re: Problem with grouping lines in table

Thu, 13 Nov 2014 11:08:06 GMT

Also i have this expression for LineAmount :

= if (InventBatchId like 'bonus', sum (CustInvoiceTrans.LineAmount))

Re: Problem with grouping lines in table

mato32188 — Thu, 13 Nov 2014 11:18:44 GMT

try to use aggr function...

example:

dimension: CustomerName

expression: sum(aggr(sum(CustInvoiceTrans.LineAmount), INVOICEID))

Re: Problem with grouping lines in table

Peter_Cammaert — Thu, 13 Nov 2014 11:31:45 GMT

Probably because InventBatchId has a single value per CustomerName/SalesID combination, but if you remove SalesID, every CustomerName will have many InventBatchId values and the IF() will fail (resulting in all NULL values)

Does it work if you change your expression into something like:

=SUM( IF ( InventBatchId LIKE 'bonus', CustInvoiceTrans.LineAmount))

Re: Problem with grouping lines in table

Thu, 13 Nov 2014 11:45:47 GMT

Thank You, I think that solve my problem