Pivot Table - Total Text

[berndjaegle]

Hi Qlik-ianers,

I want to change the text of the Total field in a pivot table to the corresponding quarter. Sounds simple, but...

This is what I want to do:

My tries for the total field:

='TOTAL Q'& MAX((RIGHT([HR.QUARTAL],1)))

//=only([HR.QUARTAL])   --> values Q1,Q2,Q3,Q4

The tricky thing: When nothing is selected, the function elaborates the whole field.

Nothing selected: it shows Q4 in all Total fields.

Because nothing is selected and all values are evaluated. (Q1,Q2,Q3,Q4)

When Quarter-field is selected:

the Max or only works, as there is only one value.

How can i make it work without a selection on Quarter-Field?

Thnx for your help.

BR,

Bernd

[tresesco]

When nothing is selected it gives the max. And it seems that, you want something else. What is that? I could not really understand the exact issue.

[berndjaegle]

It is a Pivot with Quarters and Monhts.

So I want 'Total Q1' for 1. Quarter, Total Q2, for 2. Quarter.

Now it gives Total Q4 for all Quarters. The screen shot shows it...

[tresesco]

Labels are not dimension-sensitive. I am afraid that this can't be done here like that.

[berndjaegle]

Ok thanks for you help.