Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hello!
In the field Label u can put something like this:
=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', YearFieldName & ' Sales')
Hello!
It's not working.
My label is like:
pivot table shows:
Hm..
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
Formula:
=if(isnull(GetCurrentSelections(YearFieldName)), 'All Years Sales', Concat( DISTINCT YearFieldName) & ' Sales' )
I mean in qlik sense