Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
pablomind
Contributor

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?? 

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: How to make a comparison statement?

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
Partner
Partner

Re: How to make a comparison statement?

can you give more precision about your data model ?

Partner
Partner

Re: How to make a comparison statement?

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

MVP
MVP

Re: How to make a comparison statement?

Maybe something like

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

pablomind
Contributor

Re: How to make a comparison statement?

Thank you HRLinder‌ your first suggestion solved my problem.

oknotsen
Honored Contributor III

Re: How to make a comparison statement?

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!