Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rvijayanth
New Contributor III

Editing Selection Bar

Can we change the way field names are being displayed in Selection bar after a selection is made in Qliksense?

For example I have a chart where we show only the last ten years of data. We restrict years by this expression:

if ([MyYear] > CurrentYear -11, [MyYear])

So when a selection is made in this chart, the selection bar on the top shows as follows

=if ([MyYear] >....

2014


Instead can I we have it display as follws


=MyYear

2014

1 Solution

Accepted Solutions
amartinez35
Valued Contributor

Re: Editing Selection Bar

You can try [Year] as dimension and Sum({<YEAR={">$(=[CurrentYear] -11)"}>} MyMeasure) as measure

5 Replies
rittermd
Honored Contributor

Re: Editing Selection Bar

I think you just need to change the label for the measure.  You can't put an expression in the label.  But you can get rid of the code being displayed.

rvijayanth
New Contributor III

Re: Editing Selection Bar

I just tried. Still the same code is displaying

amartinez35
Valued Contributor

Re: Editing Selection Bar

You can try [Year] as dimension and Sum({<YEAR={">$(=[CurrentYear] -11)"}>} MyMeasure) as measure

rupamjyotidas
Valued Contributor

Re: Editing Selection Bar

rvijayanth
New Contributor III

Re: Editing Selection Bar

Thank you so much. This is what I wanted.