Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Insert Sub Totals

Hi,

I need some sub totals to straight table chart. I need some totals split by CSR and Customer Code.

I have highlighted the results I need in yellow and would like to know how I "break" the report up. It is pretty easy to do in crystal as you group the csr and then add another group for the customer and then add the totals in the group footer. Assume this can be done in Qlikview. Any help would be gratefully received

   

CSRSales Order NumSales Required DateSales Order DateItem CodeSales Ordered QuantitySales Outstanding QuantitySales Order StatusCustomer Code
AE13780901/03/201624/02/2016ITEM215001500AuthorisedB2029
AE13780901/03/201624/02/2016ITEM315001500AuthorisedB2029
AE13940919/08/201629/07/2016ITEM41000000AuthorisedB2029
AE13940919/08/201629/07/2016ITEM51000000AuthorisedB2029
2030003000
AE13919822/07/201606/07/2016ITEM610000AuthorisedB2030
AE13919822/07/201606/07/2016ITEM710000AuthorisedB2030
AE13919822/07/201606/07/2016ITEM810000AuthorisedB2030
AE13947616/09/201605/08/2016ITEM95000050000AuthorisedB2030
AE13947616/09/201605/08/2016ITEM105000050000AuthorisedB2030
AE13947716/09/201605/08/2016ITEM115000050000AuthorisedB2030
AE13947716/09/201605/08/2016ITEM125000050000AuthorisedB2030
AE13996224/10/201626/09/2016ITEM1360006000AuthorisedB2030
209000206000
CamillaHemmingsen13910715/08/201622/06/2016F03938430000091456AuthorisedG7009
CamillaHemmingsen13984510/10/201614/09/2016F04115410000026452AuthorisedG7009
CamillaHemmingsen13984510/10/201614/09/2016S428-6510000026452AuthorisedG7009
500000144360
CamillaHemmingsen13719927/01/201617/12/2015F0395294000AuthorisedOD001
4000
Carole George13747301/02/201620/01/2016F0140732000600AuthorisedR18010
Carole George13747301/02/201620/01/2016S679J-602000600AuthorisedR18010
40001200
Carole George13460605/05/201514/04/2015F039463100000100000AuthorisedW23023
Carole George13480002/06/201528/04/2015F012916/130000058700AuthorisedW23023
Carole George13618606/10/201517/09/2015F0396571000008800AuthorisedW23023
Carole George13618806/10/201517/09/2015F0396561000008800AuthorisedW23023
600000176300
16 Replies
Anil_Babu_Samineni

Try from Presentation Tab for the Field of Customer Code. Put Partial Sums for that

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

sorry but I don't seem to have a sum option in the presentation tab

krishnacbe
Partner
Partner

Hi,

Hope you are using Straight table, in straight table you can have sub total. Convert the chart to Pivot and use the Partial sum to get the Sub Total.

beck_bakytbek
Master
Master

Hi Dave,

check this Topic: SUB Totals

i hope that helps

beck

jonathandienst

While it may be possible to somehow get subtotals into a straight table, it will be more complicated and probably perform poorly than simply using a pivot table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

don't have the option to load data in only have the front end

Anil_Babu_Samineni

Like This

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

that would be perfect I think

jonathandienst

Like I said, use a pivot table...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein