topic Re: Count expression for current & previous year in Text box in QlikView

Count expression for current & previous year in Text box

Wed, 23 Mar 2016 10:13:58 GMT

Hi there

I'm trying to use a text box to show the number of employees terminated in the current year and then another text box to show the number of employees terminated in the previous year. I'm using the expressions below but it's coming up blank. What am I doing wrong?

Re: Count expression for current & previous year in Text box

sunny_talwar — Wed, 23 Mar 2016 11:43:24 GMT

Try this instead:

Count({<Term_Yr = {"$(=Max(Term_Yr))"}>} Emp_No)

Count({<Term_Yr = {"$(=Max(Term_Yr)-1)"}>} Emp_No)

Re: Count expression for current & previous year in Text box

Kushal_Chawda — Wed, 23 Mar 2016 11:50:54 GMT

may be try with Total keyword

=Count(if(Term_Yr = max(Total Term_Yr ),Emp_No))

=Count(if(Term_Yr = max(Total Term_Yr )-1,Emp_No))

Re: Count expression for current & previous year in Text box

Wed, 23 Mar 2016 12:14:03 GMT

Thanks Sunny

Worked perfectly.

I still don't know how to mark these posts as "Answered"??? I only have one option to select under my "Action" tab.

Re: Count expression for current & previous year in Text box

sunny_talwar — Wed, 23 Mar 2016 15:43:38 GMT

Check here to see if it helps:

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Count expression for current & previous year in Text box

Thu, 24 Mar 2016 07:56:09 GMT

Thanks Sunny

It all seems so obvious but I don't see any "Correct Answer" button anywhere??? And I've had this problem for months, no one seems to be able to help me.