pivot table dynamic column name

[wanyunyang]

I'm trying to change pivot table column name dynamically based on the Year filter. For example, if I filter 2018, the column name shows something like "2018 sales", if filter 2017, shows "2017 sales".

Is it possible to do so? Any advice helps. Thanks!

[rafatashiro]

Hello!

In the field Label u can put something like this:

=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', YearFieldName & ' Sales')

[wanyunyang]

Hello!

It's not working.

My label is like:

pivot table shows:

[rafatashiro]

Hm..

Try to use like that

=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', Concat( DISTINCT YearFieldName) & ' Sales' )

[wanyunyang]

It seems it will show whatever I put in the label.

[rafatashiro]

You have to paste the formula in the Field Label

Formula:

=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', Concat( DISTINCT YearFieldName) & ' Sales' )

[wanyunyang]

I mean in qlik sense