topic Re: Previous year calculation in QlikView

Previous year calculation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have an expression in a table that calculates the number of enrolments when a user selects a year. I would like to add a column to the table that calculates the number of enrolments for the previous year. I am having difficulty doing this and wonder if it is because my Year field is presented in the following format e.g. 2015-16 to represent an academic year.

Thanks for any help.

Greg

Re: Previous year calculation

ahaahaaha — Fri, 23 Jun 2017 14:11:11 GMT

Hi Greg,

Maybe you will shared a small fragment of the original data and the expected result?

Regards,

Andrey

Re: Previous year calculation

Anil_Babu_Samineni — Fri, 23 Jun 2017 14:11:53 GMT

How about this?

Count({<Year = {'$(=Max(Year)-1)'}>} enrollment)

I know you have format like 2015-16. You can play with some Date format

Re: Previous year calculation

zebhashmi — Fri, 23 Jun 2017 14:48:50 GMT

try this

with same format you are calculation current year

Count({<Year = {'$(=only(Year)-1)'}>} enrollment)

other then that i think you have to make an other table

like

2015-16 July 1 2015 Jun 30 2016

2016-17 July 1 2016 Jun 30 2017

and use intervalmatch to like with you Master Calendar