Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Subtotal question. Really simple question. Please help

Hi I want to be able to total the subtotal amount. How can I do that?

This as you know gives me the Total of the whole column (CY - Territory). 

Sum(Total{$<Brand={'xyz'},[Reporting Group]={'xyz'}>}[# Amount])

RegionTerritoryCY - TerritoryCY - Territory XYX
AtlanticXYZ$1,088,104.54$46,691,919.06
AtlanticABC$1,130,739.79$46,691,919.06
AtlanticTotal$2,218,844.32$46,691,919.06

 

I would like to know the subtotal amount. How can I do that?

RegionTerritoryCY - TerritoryCY - Territory
AtlanticXYZ$1,088,104.54$2,218,844.32
AtlanticABC$1,130,739.79$2,218,844.32
AtlanticTotal$2,218,844.32$4,437,688.65

Thanks, 

J

 

2 Solutions

Accepted Solutions
Highlighted

May be this

Sum(TOTAL <Region> {$<Brand = {'xyz'}, [Reporting Group] = {'xyz'}>} [# Amount])

View solution in original post

Highlighted
Creator
Creator

10 Trillion thanks. SOLVED!

View solution in original post

3 Replies
Highlighted
Creator
Creator

Please note. I am only a front end user and I am using pivot table. If this cant be done in a pivot table how to do it in a straight table. 

Highlighted

May be this

Sum(TOTAL <Region> {$<Brand = {'xyz'}, [Reporting Group] = {'xyz'}>} [# Amount])

View solution in original post

Highlighted
Creator
Creator

10 Trillion thanks. SOLVED!

View solution in original post