Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try the same without using =
BrCatSort
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...
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)
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.
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.
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!
Hi Yuliya, did you ever find a solution? I am trying to do this as well. (I would have thought it would be simple!)