topic compare value with max(value) in set analysis in QlikView

compare value with max(value) in set analysis

curiousfellow — Mon, 10 Dec 2018 10:53:21 GMT

I cannot understand why I don't get a result with this expression.

Is it not possible to compare a fieldvalue with the max of the same field ?

=Count(distinct {$<
dateNUMtot = {"$(=Aggr(Max(dateNuMtot),employeenum))"}
>}employeenum)

naveen409 — Mon, 10 Dec 2018 11:15:44 GMT

Create one Variable for the expression

vMaxdate = max(datefield)

then create set analysis

=Count(distinct {<datefield={$(vMaxdate)}>}employeenum)

Thanks,

Naveen

lironbaram — Mon, 10 Dec 2018 11:16:08 GMT

what do you want to achieve with this expression

this doesn't works because your function in the set analysis returns

=Aggr(Max(dateNuMtot),employeenum))

a series of number one for each employee ,

in what visualization you want to use this expression

curiousfellow — Mon, 10 Dec 2018 11:31:18 GMT

I have several records for each employee. So I want to find the record with the highest dateNUMtot for each employee.

And use the value of that record as a dimension-value

I believe that when I first create a variable, it gets the value of the highest dateNUMtot of all employees

sunny_talwar — Mon, 10 Dec 2018 12:14:45 GMT

Do you have dateNUMtot as a dimension in the chart?

curiousfellow — Fri, 14 Dec 2018 09:37:47 GMT

Sorr for my late reaction, but dateNumtot is not a dimension.

I tried another expression:

in my script I added a field containing the highest date

But count({<enddate = {"$(=highest_enddate)"} >}employee) does not give correct results too.

neither does count({<enddate = {"enddate=highest_enddate"} >}employee)

It does when I select one employee, but when I do not select an employee there are no results

When comparing both fields with an if statement they are counted as equal

sunny_talwar — Fri, 14 Dec 2018 12:24:16 GMT

What exactly is your chart dimension?

curiousfellow — Tue, 18 Dec 2018 14:08:46 GMT

My dimension is another field. In this situation first year of employment.

sunny_talwar — Tue, 18 Dec 2018 14:21:31 GMT

Would you be able to share a sample or sample data with the expected output?