Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Count Year by year

Hi,

I am trying to create a line chart with two measures that will show the current year and the previous year only. My only dimension is a field MonthYr. The current expression I am using to show all of the data is Count({<MissionStatusSK ={1347}>}Distinct InjurySK). I am needing to show only the injuries that have a status of 1347 for the current year and the previous year. I am having trouble with figuring out how to modify my expression to only include dates that fit the criteria. Any help would be greatly appreciated.

Thanks,

Phil Radovich

1 Reply
Highlighted
Partner
Partner

Have you created a master calendar?

If you have use set analysis to achive the same. e.g.

Year={"$(=Year(Max(OrderDate)))","$(=Year(Max(OrderDate))-1)"}

if you dont have a master calendar would recommend creating one