topic Re: Custom Totals Labels in QlikView

Custom Totals Labels

Thu, 17 Oct 2013 04:05:12 GMT

Hi,

I have the following report:

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

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

Thanks

Dave

jagan — Thu, 17 Oct 2013 04:22:25 GMT

Hi Dave,

Try like this

Regards,

Jagan.

sushil353 — Thu, 17 Oct 2013 04:35:37 GMT

Hi David,

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

HTH

Sushil

Thu, 17 Oct 2013 04:38:27 GMT

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 — Thu, 17 Oct 2013 04:43:50 GMT

Please upload a sample application for better resolution.

Thu, 17 Oct 2013 04:56:55 GMT

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

sushil353 — Thu, 17 Oct 2013 05:14:50 GMT

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

Thu, 17 Oct 2013 05:17:36 GMT

ok thanks, I guess something for Qlikview 17 or whenever

jagan — Thu, 17 Oct 2013 05:42:09 GMT

Hi David,

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

Regards,

Jagan.