topic What is wrong in my expression? in QlikView

What is wrong in my expression?

harleen_singh — Mon, 25 Feb 2013 11:55:57 GMT

Attached is the sample.

If you look at the expression - (minus) i have used following formula.

count( DISTINCT { $< EmployeeNo = P ({< Date = {"$(MinDate)"}>} EmployeeNo )/ P ({< Date = {"$(Lastdate)"}>} EmployeeNo )>} EmployeeNo)

All the figures are correct but if you check company id 0102

it shows 1 in -(minus) which is wrong but when u make selection of 0102 it gives u correct figure i.e 3 .

I am completely stucked in this ? What is wrong in my expression ??

thanks

Lavi

Re: What is wrong in my expression?

perumal_41 — Mon, 25 Feb 2013 12:24:13 GMT

Hi Lavi

I have attached one Application Please check is correct or not .i don't have your qvd.so iyour application take binary load,then employee table Resident for companiation Employeeno and Company.This is field i used in Expression.

Regards

Perumal A

Re: What is wrong in my expression?

harleen_singh — Tue, 26 Feb 2013 07:03:43 GMT

@Perumal A,

it really worked perfectly man

thanks

Lavi