Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ismail_93
Contributor
Contributor

set analysis

Hello,

 

I have this issue "Use Date in SET Analysis, yet ignore a Date selection".

I calculat "number of employees KPI"  like this : 

Count({<

[Entry date]={"<=$(=MONTHEND('01/'&Mois&'/'&[Année]))"},
[Relaese date]={">=$(=MONTHEND('01/'&Mois&'/'&[Année]))"},

Mois=,
[Année]=,
[Comptabilisation effectifs]={'Y'}>}

Distinct salarie_matricule )

so when i select month number January and year 2020 i get my KPI.

Ismail_93_0-1616584375321.png

Right now i want to present "Board" in the same sheet  where i want to show "number of employees" by all months of years and ignore a Date selection. For that i used : 

Count({<

[Entry date]={"<=$(=MONTHEND({<[Date started période]=>}[Date started période]))"},
[Relaese date]={">=$(=MONTHEND({<[Date end période]=>}[Date end période]))"},

Mois=,

[Comptabilisation effectifs]={'Y'}>}
Distinct salarie_matricule)

 I get as result for 2020 this board : 

Ismail_93_1-1616584751276.png

Can someone please tell me why i didn't get 8707 in the board as it is presented in the firs KPIs ?

Thank you

0 Replies