Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

How to make a comparison statement?

Hi, Im working on a HR Dashboard and I need to know how many active employee has more than one position assigne. I have a column of employee ID and another one with positions. Any suggestion?? 

1 Solution

Accepted Solutions
Anonymous
Not applicable

several ways

1) Expression using aggr with empoyeeID as dimension

if (aggr(Count(Position),EmplyeeID) > 1, Count(Position))

2) employeeID as Dimension

  Count(position) as Expression

  Dimension Limit (Show only values thar are gretaet than 1 exact amount)

-> only if Count (Position) is first expression

View solution in original post

5 Replies
mohamed_ahid
Partner - Specialist
Partner - Specialist

can you give more precision about your data model ?

Anonymous
Not applicable

several ways

1) Expression using aggr with empoyeeID as dimension

if (aggr(Count(Position),EmplyeeID) > 1, Count(Position))

2) employeeID as Dimension

  Count(position) as Expression

  Dimension Limit (Show only values thar are gretaet than 1 exact amount)

-> only if Count (Position) is first expression

swuehl
MVP
MVP

Maybe something like

=Count({<EmpID = {"=Count(DISTINCT Position) >1"}>} DISTINCT EmpID)

pablomind
Creator
Creator
Author

Thank you HRLinder‌ your first suggestion solved my problem.

oknotsen
Master III
Master III

It seems you have the answer to your question. Now it is time for you to flag the correct answer by using the Correct Answer flag.

May you live in interesting times!