topic Re: how to count in QlikView

how to count

Wed, 21 Aug 2013 08:27:59 GMT

hello !

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)

thanks !

Re: how to count

sparur — Wed, 21 Aug 2013 08:38:30 GMT

I think the IntervalMatch will help you.

Re: how to count

Wed, 21 Aug 2013 08:44:08 GMT

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.

Re: how to count

Wed, 21 Aug 2013 08:44:32 GMT

try intervalmatch then count.

after that try this code

=count(distinct [Person Name])

see attached file on interval match

Regards

Re: how to count

Wed, 21 Aug 2013 11:20:05 GMT

thank you, i'm trying this