# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## Re: Showing negative values in Year over year by month

Like in below image i need to show graph. For both current(Green) and previous year(red) of  invitations and Course Completed YOY Counts.

Honored Contributor III

this?

Contributor II

## Re: Showing negative values in Year over year by month

Yes.

But it has to show for both current and previous year.

Highlighted
Honored Contributor III

## Re: Showing negative values in Year over year by month

add two expression for current and previous year

cuu yr:

count({<DateType = {Completed},

Canon_Year = {"\$(=year(max(CanonicalDate)))"}>}course_completed)

pre Yr:

count({<DateType = {Completed},

Canon_Year = {"\$(=year(max(CanonicalDate))-1)"}>}course_completed)

Contributor II

## Re: Showing negative values in Year over year by month

I am not able to add one more expression, ADD button of Measures is not Highlighted.Thats the problem i am facing.

Honored Contributor III

## Re: Showing negative values in Year over year by month

in line chart u can add measures as u want. check properly under expression

Contributor II

## Re: Showing negative values in Year over year by month

You wont be able to add Expression more than one

Honored Contributor III

## Re: Showing negative values in Year over year by month

try the option add alternative measure

Contributor II

## Re: Showing negative values in Year over year by month

Nothing get displayed if i add in Alternate measure, in line graph

Contributor II

## Re: Showing negative values in Year over year by month

Hi,

I need to Show counts YOY of completions and Invitation in Line Graph.

I have dimension : Year and Month

Expression:

fabs(count({<DateType = {invitation},

Year = {\$(=max(Year))}>}invitation_id)-count({<DateType = {invitation},

Year = {\$(=max(Year)-1)}>}invitation_id)

)

Here i need to add one more expression, but i am not able to add onemore expression.

Can we add more than one expression while calculating YOY by month??