topic How to make a comparison statement? in QlikView

How to make a comparison statement?

pablomind — Mon, 08 Feb 2016 09:30:38 GMT

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

Re: How to make a comparison statement?

mohamed_ahid — Mon, 08 Feb 2016 14:50:18 GMT

can you give more precision about your data model ?

Re: How to make a comparison statement?

Anonymous — Mon, 08 Feb 2016 14:56:44 GMT

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

Re: How to make a comparison statement?

swuehl — Mon, 08 Feb 2016 14:57:12 GMT

Maybe something like

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

Re: How to make a comparison statement?

pablomind — Mon, 08 Feb 2016 15:00:57 GMT

Thank you HRLinder‌ your first suggestion solved my problem.

Re: How to make a comparison statement?

oknotsen — Mon, 08 Feb 2016 16:31:06 GMT

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.