Count on a field for a specific (max) year without any selection
My Data will have details from past 10 years. I want to show some info when the users brings up or get into the apps/dashboard.
The details are for the active employees at the given point of time.
Like:
1. Count of active employees as of today for the current year and max of the month in the table ( see the attached xls file). See the qvw file to see where I need.
2. Similary, I want to compare quarters for max(year) with quarters for prev year in a separate chart/tab. How can this be done using set expression something like
with dimension as sex, emp_category and expression something like
if ( $<Quarter={'Q'}>}, COUNT({$<QuarterID = {$(=Max(QuarterID))