Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have posted previously one request but it was marked as spam. My applogies if it is duplicate
I am new to Qlikview. So trying to create an output table from below input table. (Please igonore colour marking in every row. I have marked in colour for you to identify and differentiate the data easily. Final Table I do not need any colour)
Currently I have data for multiple bills. Some bills may have more than one line items. I want to create a bill wise table as per below (All GST, Taxes sum together create one line item)
How do Do it?
Thank you
This is simple in Qlikview rite , try like this
Add dimension
1. Bill Date
2. Bill Number
3. Vendor Name
Expressions :
Sum(IGST)
Sum(CGST)
Sum(SGST)
Sum(Total Tax)
Sum(Item Total)
Sum(DISTINCT Sub Total)
Sum(DISTINCT Total Amount)
This is simple in Qlikview rite , try like this
Add dimension
1. Bill Date
2. Bill Number
3. Vendor Name
Expressions :
Sum(IGST)
Sum(CGST)
Sum(SGST)
Sum(Total Tax)
Sum(Item Total)
Sum(DISTINCT Sub Total)
Sum(DISTINCT Total Amount)
Thanks it worked . Appreciate
Since I have multiple line item, Is there any way I can get DISTINCT Bill NUmber?