topic Re: Current year count vs Previous year count in App Development

Current year count vs Previous year count

Wed, 11 Feb 2015 15:18:02 GMT

I have these fields in my database, PayRollYear and PayRollMonth and EMPNO.

I want to create a combo chart, that shows the count of employees in the present year vs the previous year. Present year would be a bar chart, and previous year would be a line chart, month being the dimension. Any ideas????

Re: Current year count vs Previous year count

Anonymous — Wed, 11 Feb 2015 15:42:39 GMT

Hello,

- Create a variable something like vMaxYear=max(Year).

- Another variable, PrevYear = vMaxYear-1

- Comcbo chart. 1 Dimension, Month; 2 Expressions:

sum({<Year='$(vMaxYear)'>}Expression1)

sum({<Year='$(vPrevYear)'>}Expression1)

Serhan

Re: Current year count vs Previous year count

Wed, 11 Feb 2015 15:46:59 GMT

you mean, vMaxYear = max(PayRollYear)?

Re: Current year count vs Previous year count

Wed, 11 Feb 2015 15:57:28 GMT

And also, where dao I create these variables?

Re: Current year count vs Previous year count

Anonymous — Wed, 11 Feb 2015 15:58:00 GMT

Yes.

Sorry this is Qlik Sense though. You cannot create variables as in Sense.

Instead ;

sum({<Year={'$(=max(PayRollYear))'}>}Expression1)

sum({<Year={'$(=max(PayRollYear)-1)'}>}Expression1)

Serhan

Re: Current year count vs Previous year count

Wed, 11 Feb 2015 16:04:33 GMT

Thanks a lot!

Re: Current year count vs Previous year count

Wed, 11 Feb 2015 16:37:28 GMT

I am using Qlikview, and if I do as you said, it's giving the same value for both, current and previous.

Re: Current year count vs Previous year count

Anonymous — Wed, 11 Feb 2015 20:34:14 GMT

Here we go.

Serhan

Re: Current year count vs Previous year count

Fri, 13 Feb 2015 13:15:38 GMT

???

Re: Current year count vs Previous year count

Anonymous — Fri, 13 Feb 2015 13:29:12 GMT

Hello,

Open it in QlikView and just copy the formula. That's all.

Serhan

Re: Current year count vs Previous year count

Fri, 13 Feb 2015 13:40:33 GMT

Hey,

I am sorry, but what am I suppose to open? There isn't any file attached, in you reply.

Shreya

Re: Current year count vs Previous year count

Anonymous — Fri, 13 Feb 2015 13:43:17 GMT

You can'see this?

Re: Current year count vs Previous year count

Fri, 13 Feb 2015 13:51:22 GMT

Nope!!!

Re: Current year count vs Previous year count

Anonymous — Fri, 13 Feb 2015 14:25:39 GMT

Hi,

No need to create variable in your case.

Create a graph with dimension Month and two expressions:

First expression in bar chart:

count(distinct {<PayRollYear ={$(=Max(PayRollYear))}>}EMPNO)

Second expression in line chart:

count(distinct {<PayRollYear ={$(=(Max(PayRollYear)-1))}>}EMPNO)