Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Total Sum Split Expression

I need to get a sum of a split charges expression. The expression was previously created as I need only 1 charge of 19.64 per Dealer per day. But now I need to sum these individual 19.64 charges to get a total per dealer. I have the split sum working in the pivot table fine but now i need to sum those 19.64s to create a variance against the other freight charge for the Total Freight Charge table.

I've attached a qvw with the different expressions in it to see if anyone can help. The TOTAL expression messes it up slightly

1 Solution

Accepted Solutions
sunny_talwar

What is a numeric output you are expecting to see and which of the two charts? If this is for the Total Freight Charge, may be this

Sum(Aggr($(vNewIntFreightCharge), ORDER_NUMBER, DATE, Name))

to get 608.84?

View solution in original post

4 Replies
trdandamudi
Master II
Master II

What is your expected output ? I don't see a field [Total Ransomes Freight Charge] in your data model ...?

khaycock
Creator
Creator
Author

I need a sum of all 'Split UPS Freight Charges' for each 'Dealer'

sunny_talwar

What is a numeric output you are expecting to see and which of the two charts? If this is for the Total Freight Charge, may be this

Sum(Aggr($(vNewIntFreightCharge), ORDER_NUMBER, DATE, Name))

to get 608.84?

View solution in original post

vishsaggi
Champion III
Champion III

Is this what you are expecting?

Capture.PNG