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))
,Year = ,Quarter = ,Month = >} DISTINCT PERSON_ID))
You help is highly appreciated.
