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!
In the field Label u can put something like this:
=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', YearFieldName & ' Sales')
It's not working.
My label is like:
pivot table shows:
Try to use like that
=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', Concat( DISTINCT YearFieldName) & ' Sales' )
It seems it will show whatever I put in the label.
You have to paste the formula in the Field Label
I mean in qlik sense
Retrieving data ...