Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
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.


Capture.PNG

arulsettu
Honored Contributor III

Re: Showing negative values in Year over year by month

this?

Untitled.png

Highlighted
berryandcherry6
Contributor II

Re: Showing negative values in Year over year by month

Yes.

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

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

berryandcherry6
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.

arulsettu
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

Untitled.png

berryandcherry6
Contributor II

Re: Showing negative values in Year over year by month

Check by adding two Dimension.

You wont be able to add Expression more than one

arulsettu
Honored Contributor III

Re: Showing negative values in Year over year by month

try the option add alternative measure

berryandcherry6
Contributor II

Re: Showing negative values in Year over year by month

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

berryandcherry6
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??