This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a problem with QlikView Totals.
From above table, we have an invoice number and respective Sales and Qty.
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:
Please let me know, how to get above report.
Many thanks in Advance.
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.
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,