topic Re: Dimension Limits Totals label in QlikView

Dimension Limits Totals label

danielact — Wed, 05 Jun 2013 14:34:32 GMT

I have a straight table, and I'm using the Totals feature in the Dimension Limits tab to show subtotals. I'd like to customize the label to pull in the value of the dimension. Here's an example of what it shows, and then what I'd like to get to:

Department Contract # Cost

Legal 111A 1000

Legal 112A 2000

Legal 113A 3000

Legal Total 6000

Sales 211A 5000

Sales 212A 6000

Sales 213A 3000

Sales 214A 4000

Sales Total 18000

I'd like to get to this:

Department Contract # Cost

Legal 111A 1000

Legal 112A 2000

Legal 113A 3000

Total for Legal (3 contracts) 6000

Sales 211A 5000

Sales 212A 6000

Sales 213A 3000

Sales 214A 4000

Total for Sales (4 contracts) 18000

Any ideas on how to do that?

Re: Dimension Limits Totals label

MEllinghausen — Wed, 05 Jun 2013 14:51:27 GMT

hey,

you can try under PräsentationTAB "description of Suptotales"? in german 'Bezeichnung für gesamtwerte' like this formula

='Total for ' & department & '( ' count(contracts) &')'

Marcus

Re: Dimension Limits Totals label

Gysbert_Wassenaar — Wed, 05 Jun 2013 17:57:41 GMT

Unfortunately that's not possible. You get only one label for all the totals from the Show Totals option of the dimension limits. Any expression you use in the label won't be able to use the charts dimensions to aggregate on.

Re: Dimension Limits Totals label

MEllinghausen — Thu, 06 Jun 2013 15:50:55 GMT

Gysbert you are right, I try It out.

Marcus

Re: Dimension Limits Totals label

danielact — Fri, 07 Jun 2013 14:08:46 GMT

I actually figured out how to do it. This formula might not work exactly for my example above, but here's what I did:

I set up Department as a Dimension, then hid it. I also set up an Expression for Department, with this formula:

if(Dimensionality()=2,'Total for '&Department&' = '& Count(ContractNum),if(Dimensionality()=0,'Grand Total = '&Count(ContractNum),Department))