I have 3 fields about personnes in an business : on for date of entry (hiring) in the business and one for date of output and on for the name of the personn...
I want to stok in a variable the amount of personn that are activ in the compagny, when i make a selection (year, onth...) in the dashboard...
ps : some personn can enter and be returned of the compagny more than only 1 time...
can someone help me to make this variable? (i am a beginner in qlikview)
It depends on how your data model is built, but the easiest way to achieve that is using:
=count(DISTINCT [Person Name])
If you want to store this value in a variable every time a selection is made to the month or the year field, you have to go to:
Configuration >> Document Properties...
and there, in triggers tab, add a field event procedure to the month and year fields. They must set the variable you want with the count expression every time they change.
