Qlik Community

App Development

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

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
philip_radovich
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
dilipranjith
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