topic Re: Pivot Table - Total Text in QlikView

Pivot Table - Total Text

berndjaegle — Thu, 01 Nov 2018 08:20:15 GMT

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

tresB — Thu, 01 Nov 2018 08:46:49 GMT

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 — Thu, 01 Nov 2018 08:54:22 GMT

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...

tresB — Thu, 01 Nov 2018 09:13:39 GMT

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

berndjaegle — Thu, 01 Nov 2018 09:43:33 GMT

Ok thanks for you help.