Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RutiTRubin
Contributor

filter in dimensions field in combochart - qliksense

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!!

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: filter in dimensions field in combochart - qliksense

create 2 variables

vMinYear = Min(TOTAL Year)

vMaxYear = Max(TOTAL Year)



Change expression to, for example


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



1 Reply
vinieme12
Esteemed Contributor II

Re: filter in dimensions field in combochart - qliksense

create 2 variables

vMinYear = Min(TOTAL Year)

vMaxYear = Max(TOTAL Year)



Change expression to, for example


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



Community Browser