Problem in Totals and straight table

[munna1317]

Dear Team,

I have a problem with QlikView Totals.

Case 1:

Type	Coat	Color	Invoice Number	InvoiceDate	Sales	Qty
					201.26	2
B-13BB	JJAAKK	BB2B	BBBB1212	02-01-2018	201.26	2

From above table, we have an invoice number and respective Sales and Qty.

Case 2:

Type	Coat	Color	Invoice Number	InvoiceDate	PurchaseNo	Sales	Qty
						201.26	2
B-13BB	JJAAKK	BB2B	BBBB1212	02-01-2018	123	122.34	2
B-13BB	JJAAKK	BB2B	BBBB1213	02-01-2018		78.92	0

From Case 2, we have PurchaseNo Field Extra with 2 lines. My requirement is when i export this report it should come like below Report.

Output of Export to Excel:

Type	Coat	Color	Invoice Number	InvoiceDate	PurchaseNo	Sales	Qty
						201.26	2
B-13BB	JJAAKK	BB2B	BBBB1212	02-01-2018	123	201.26	2

Please let me know, how to get above report.

Many thanks in Advance.

Harish

[kaushiknsolanki]

Hi Harish,

It is not the Qlik total issue, but its your data issue.

If you want the total of 201.26 under one purchase no, you will have to change your transnational data. Or find logic to fill the Purchase no in later row.

Regards.

Kaushik Solanki

[munna1317]

Dear Kaushik,

Thanks for your valuble replay,

as you said, its true, but data is coming from DB we can't edit data for Nulls values with Respective Invoice ID Right??

How we can map those Purchase No with Invoice ID ??

Can you please suggest.

Thanks in Advance,

Harish