Label Totals in automatical Partial sums by current field value

[#1]

Good day!

Please suggest: is it possible to label Totals in automatical Partial sums by current field value?

There is the print screen in attachment displaying the problem.

Label for Totals as field BrCatSort doesn't work...

I need to get Total Label as current value of  BrCatSort in table.

Thanks in advance!

[MK_QSL]

Try the same without using =

BrCatSort

[#3]

It this case Qlikview displays total just as text "BrCatSort", but i need concrete current value of this field - "Juices & Nectars" in first total and then "CSD" in the second and so on...

[SunilChauhan]

you can use expression for that field as i see above Juice &Nectars after Equal to

it will show you in

or only(That expression)

[Roop]

I think that you should be able to use =MaxString(BrCatSort). QlikView doesn't realise that all the values are the same so needs the MaxString to sort.

[jagan]

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.

[#7]

MaxString will return value with maximal symbols, it will be the same for all subtotals, but i need the dynamic labels - unigue for each category.

For example for Juices & Nectars it will be total label Juices & Nectars, for CSD - CSD, in other words the current value of the field:

Juices & Nectars	Sadochok
	Sandora
	Juices & Nectars
CSD	Pepsi
	Mirinda
	CSD

Is it possible?

Thanks!

[#8]

Hi Yuliya, did you ever find a solution?  I am trying to do this as well.  (I would have thought it would be simple!)