Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

Problem in Totals and straight table

Dear Team,

I have a problem with QlikView Totals.

Case 1:

      

TypeCoatColorInvoice NumberInvoiceDateSalesQty
201.262
B-13BBJJAAKKBB2BBBBB121202-01-2018201.262

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

Case 2:

      

TypeCoatColorInvoice NumberInvoiceDatePurchaseNoSalesQty
201.262
B-13BBJJAAKKBB2BBBBB121202-01-2018123122.342
B-13BBJJAAKKBB2BBBBB121302-01-201878.920

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:

      

TypeCoatColorInvoice NumberInvoiceDatePurchaseNoSalesQty
201.262
B-13BBJJAAKKBB2BBBBB121202-01-2018123201.262

Please let me know, how to get above report.

Many thanks in Advance.

Harish

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
munna1317
Creator II
Creator II
Author

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