Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

atikahsuhaimy
New Contributor

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.

Tags (2)
4 Replies
dwforest
Valued Contributor

Re: How to display latest month only in qlik sense dimension

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

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

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

atikahsuhaimy
New Contributor

Re: How to display latest month only in qlik sense dimension

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.

atikahsuhaimy
New Contributor

Re: How to display latest month only in qlik sense dimension

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.

laurischarf
Contributor II

Re: How to display latest month only in qlik sense dimension

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


Community Browser