How to display latest month only in qlik sense dimension

[Anonymous]

Hi Everyone,

I want to display january and february only in this line chart.

Thank you.

[dwforest]

Sum({$<Month={1,2}>} [Action Required])

If the other months in your data are from different years..

Sum({$<Year={$(=Year(Today()))}>} [Action Required])

[Anonymous]

What the data that I need to put in action required?

I tried do like this -> =Sum({$<[CBMIOINPUT.YR]={$(=[CBMIOINPUT.YR](Today()))}>} [Action Required]) . but it shows invalid dimension.

[Anonymous]

What the data that I need to put in action required?

I tried do like this -> =Sum({$<[CBMIOINPUT.YR]={$(=[CBMIOINPUT.YR](Today()))}>} [Action Required]) . but it shows invalid dimension.

[Lauri]

Use the dimension you used in the line chart to get Total Status. I am guessing its name is not "Action Required"...

And [CBMIOINPUT.YR](Today()) is not valid.

As David suggested, to get this year's Jan and Feb data:

Sum({$<[CBMIOINPUT.YR]={"$(=Year(Today()))"}, [CBMIOINPUT.YR]={1,2}>} [your dimension's name])