Max Quarter - Based on financial years - Qlik Community

helen_pip · ‎2016-10-26

Dear Qlikview User

I have been searching for a suitable answer on the internet, but there are so many variations to choose from, however there does not seem to be a suitable answer available for my dataset

I am looking for an expression to always show data for the most current quarter for the most recent year

My set up is that I am using a master calendar which is loading in 3 financial years for all my data sets

I have a field in the master calendar called Quarter which returns: Q1,Q2,Q3,Q4

Q1 = Apr-Jun

Q2 = Jul-Sep

Q3 = Oct-Dec

Q4 = Jan-Mar

I have a Year Start field which is showing the following:

2014-15 - 01/04/2014-31/03/2015

2015-16 - 01/04/2015-31/03/2016

2016-17 - 01/04/2016- 26/10/2016

What I need to achieve is a count of Unique_ID where the Year Start is 2016-17 and the quarter is the most current quarter, which at the present time, should be Q3

Could anyone kindly help me set me in the right direction to try and achieve this...

Kind Regards

Helen

sunny_talwar · ‎2016-10-26

May be like this:

Count({<[Year Start] = {"$(=MaxString([Year Start]))"}, Quarter = {"$(=MaxString({<[Year Start] = {'$(=MaxString([Year Start]))'} Quarter))"}>}Unique_ID)