topic Expression help in QlikView

Expression help

Tue, 02 Apr 2013 09:17:08 GMT

hi everyone,

I have the following expression

=aggr(if([WO Employee Code] = EmployeeCode_Sales, Sum(AbsentFlag_ISS)),EmployeeCode_Sales,EmployeeName)

I was wondering if anyone had any suggestions on how to rewrite this to make it perform better as currently it takes the chart 6min 57secs to render.

Any help would be appreciated.

Thanks

Re: Expression help

kaushiknsolanki — Tue, 02 Apr 2013 09:22:35 GMT

Hi,

Try this.

Sum(Aggr(sum({<[WO Employee Code] = {"=[WO Employee Code] = EmployeeCode_Sales"}>}AbsentFlag_ISS),EmployeeCode_Sales,EmployeeName))

Regards,

Kaushik Solanki

Re: Expression help

Tue, 02 Apr 2013 09:32:02 GMT

Hi Kaushik,

Thanks for your reply, that unfortunately doesnt work. it puts the same figure against each row. I need to to obviously calculate at row level using the name field.

The first aggr expression are the correct figures, the second is yours which is a total sum of the field against each employee.

Re: Expression help

kaushiknsolanki — Tue, 02 Apr 2013 09:34:49 GMT

Hi,

Kindly upload the example document.

Regards,

Kaushik Solanki

Re: Expression help

Tue, 02 Apr 2013 10:27:36 GMT

Hi, attached is a sample..

I have scrambled the data apart from the fields needed.

Thanks

Re: Expression help

Gysbert_Wassenaar — Tue, 02 Apr 2013 11:04:46 GMT

You can't solve this with set analysis expressions. You should create a link between DiaryEvent_Sales and WorkOrder in the script. I think you need a third table for the link. If you link the tables directly you get a useless many-to-many relationship.

Re: Expression help

kaushiknsolanki — Tue, 02 Apr 2013 11:11:13 GMT

Hi,

I agree with Gysbert. It is not possible with Set Analysis, you must join both the fields.

Regards,

Kaushik Solanki