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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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