Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to display latest month only in qlik sense dimension

line chart.png

Hi Everyone,

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

Thank you.

4 Replies
dwforest
Specialist II
Specialist II

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

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

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

Anonymous
Not applicable
Author

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

year.PNG

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

Anonymous
Not applicable
Author

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


year.PNG


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

Lauri
Specialist
Specialist

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])