Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom Totals Labels

Hi,

I have the following report:

Brand NameSKU TypeSKUSKU DescriptionSep 13 - MTD SalesSep 12 - MTD SalesGrowth
First ClassFocusFC40113First Class Taser$6,903$8,906-22.5%
First ClassFocusFC40114First Class Pepper Spray$40,997$33,06524.0%
First ClassFocusFC50120First Class Knuckle Dusters$48,235$60,290-20.0%
First ClassFocusFC50121First Class Pet Shampoo$4,453$2,88954.1%
First ClassFocusTotal $100,587$105,151-4.3%
First ClassOtherOtherOther$88,451$105,322-16.0%
First ClassOtherTotal $88,451$105,322-16.0%
First ClassTotal $189,038$210,473-10.2%

I want to create custom subtotals so it appears as below:

Brand NameSKU TypeSKUSKU DescriptionSep 13 - MTD SalesSep 12 - MTD SalesGrowth
First ClassFocusFC40113First Class Taser$6,903$8,906-22.5%
First ClassFocusFC40114First Class Pepper Spray$40,997$33,06524.0%
First ClassFocusFC50120First Class Knuckle Dusters$48,235$60,290-20.0%
First ClassFocusFC50121First Class Pet Shampoo$4,453$2,88954.1%
First ClassFocusFocus Total $100,587$105,151-4.3%
First ClassOtherOtherOther$88,451$105,322-16.0%
First ClassOtherOther Total $88,451$105,322-16.0%
First ClassTotal $189,038$210,473-10.2%

Is there a formula I can add to the Presentation tab under "Labels for Totals" that will do this?

Thanks

Dave

8 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Dave,

Try like this

http://community.qlik.com/docs/DOC-3860

Regards,

Jagan.

sushil353
Master II
Master II

Hi David,

If you are using pivot table then you can use partial sum in presentation tab.

HTH

Sushil

Not applicable
Author

I am using "show partial sums" but I need a formula to be able to insert the value in the "SKU Type" column into the total in the SKU column

sushil353
Master II
Master II

Please upload a sample application for better resolution.

Not applicable
Author

This is a simple version, I want the total under SKU to say =[SKU Type] & ' Total' but this doesnt work

sushil353
Master II
Master II

Sorry to say but i dont think that you can attach dimension values with total as label

Not applicable
Author

ok thanks, I guess something for Qlikview 17 or whenever

jagan
Luminary Alumni
Luminary Alumni

Hi David,

There is no direct setting for this, you can try like this in the sample attached

http://community.qlik.com/docs/DOC-3860

Regards,

Jagan.