Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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