topic Re: aggr inside set analysis in QlikView

aggr inside set analysis

harleen_singh — Tue, 19 Feb 2013 08:45:31 GMT

Hello ,

i want to use aggrageta inside this set analysis how to do that?

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

for example i want aggr following with Date and one more dimension say "Company ID" and use it inside above expression.

P ({<Date = {"$(MinDate)"}>} EmployeeNo)

thanks

Lavi

Tue, 19 Feb 2013 09:06:16 GMT

Hi,

You can try this statement.

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

P ({<Date = {"$(Lastdate)"}>} EmployeeNo )>} EmployeeNo),Date,CompanyID)

Regards,

Janzen

harleen_singh — Tue, 19 Feb 2013 09:19:51 GMT

i have already tried but it didn't work. I want to try inside the set analysis.

thanks

Tue, 19 Feb 2013 09:26:17 GMT

hi,

Could you please attach a sample file?

Regards,

Janzen

harleen_singh — Thu, 21 Feb 2013 05:06:52 GMT

Janzen,

attached is the sample. If you look at the expression - (minus) i have used above formula.

if you check company id 0102

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

thanks

Lavi

harleen_singh — Mon, 25 Feb 2013 04:36:35 GMT

u checked out sample??

thanks

Lavi