Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
MVP & Luminary
MVP & Luminary

Re: Custom Totals Labels

Hi Dave,

Try like this

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

Regards,

Jagan.

sushil353
Honored Contributor II

Re: Custom Totals Labels

Hi David,

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

HTH

Sushil

Not applicable

Re: Custom Totals Labels

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
Honored Contributor II

Re: Custom Totals Labels

Please upload a sample application for better resolution.

Not applicable

Re: Custom Totals Labels

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

sushil353
Honored Contributor II

Re: Custom Totals Labels

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

Not applicable

Re: Custom Totals Labels

ok thanks, I guess something for Qlikview 17 or whenever

MVP & Luminary
MVP & Luminary

Re: Custom Totals Labels

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.