filter in dimensions field in combochart - qliksense

[RutiTaumanRubin]

Hello,

I create bar chart with 2 measure and one dimension - Year.

I want to filter in the dimension (not in the measure) so it will bring me only the max & min Year.

Any Idea?

Thank's!!

[vinieme12 · Accepted solution]

create 2 variables

vMinYear = Min(TOTAL Year)

vMaxYear = Max(TOTAL Year)

Change expression to, for example

=SUM(   {<  Year = {$(vMinYear),$(vMaxYear)} >} Sales)