Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
i have to count all the active employee from selected year till minimum year in the list.
guide me how i should do this i m new to qlikview.
Regards.
Tayyab
send some data sample (qvw )
Hi,
Try like this,
=Count({<Year = {'>=$(=Min({1}Year)) <= $(=Max(Year))'}>}Distinct Employees)
It gives count of distinct employees from selected year to minimum year in your list.
Hope it helps
hi
if i want to use the same formula for the selected year ,month and day.
hi
if i want to use the same formula for the selected year ,month and day.