Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
DarkTemplar
Contributor
Contributor

Help set analysis embedded expression

Hello,
I am trying to make a dashboard for my application but I am stuck on filling in my KPI. I'm looking to get the number of people with >= 6 days of absence of type "" but the formula always returns 0.

count({$<Nom = {"Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)

Nom

Type de congés

Conges_Date

Daniel

non régularisé

14/11/2022

Daniel

non régularisé

15/11/2022

Daniel

non régularisé

16/11/2022

Julie

Décès

12/04/2022

Julie

Décès

14/04/2022

Bruno

non régularisé

19/04/2022

Bruno

non régularisé

20/04/2022

Bruno

non régularisé

21/04/2022

Bruno

non régularisé

22/04/2022

Bruno

non régularisé

23/04/2022

Bruno

non régularisé

24/04/2022

Bruno

non régularisé

25/04/2022

Emma

Décès

02/05/2022

Emma

Décès

03/05/2022

Emma

Décès

04/05/2022

Pierre

non régularisé

17/06/2022

Pierre

non régularisé

18/06/2022

Pierre

non régularisé

19/06/2022

Pierre

non régularisé

20/06/2022

Pierre

non régularisé

21/06/2022

Laura

Mariage/PACS

05/08/2022

Laura

Mariage/PACS

07/08/2022

Laura

Mariage/PACS

08/08/2022

Laura

Mariage/PACS

09/08/2022

Laura

non régularisé

31/10/2022

Laura

non régularisé

01/11/2022

Laura

non régularisé

02/11/2022

 

Thank you for your answer.

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Just a quick glance says, you are missing one '='. Try like:

count({$<Nom = {"=Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)

View solution in original post

2 Replies
tresesco
MVP
MVP

Just a quick glance says, you are missing one '='. Try like:

count({$<Nom = {"=Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)

DarkTemplar
Contributor
Contributor
Author


@tresesco wrote:

Just a quick glance says, you are missing one '='. Try like:

count({$<Nom = {"=Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)


Perfectly functional, thank for the correction