Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aunahsan
New Contributor III

Two different expression in the same chart

Hello!

I have a small problem that i am trying to figure out, any help would be great.

I have a line chart that has Month-Year as its dimensions. Its a rolling 12 months figure.

the problem is that i need to use two different calculations for the different years. is this something that's possible?

so for the months March to Dec 2017 it uses a different calculation and for Jan-Feb 2018 it uses a different calculation.

i have tried IF to say if with getcurrentfieldselections(Year)='2017', MyExression, OtherExpression)

but it doesnt work until i click on the year 2017.

Thanks allot!

Tags (1)
1 Solution

Accepted Solutions

Re: Two different expression in the same chart

May be try this

If(Year = 2017, MyExpression, OtherExpression)

1 Reply

Re: Two different expression in the same chart

May be try this

If(Year = 2017, MyExpression, OtherExpression)

Community Browser