Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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))

,Year = ,Quarter = ,Month = >} DISTINCT PERSON_ID))

You help is highly appreciated.

0 Replies