topic Re: from set analysis to script during load in QlikView

from set analysis to script during load

Wed, 25 Nov 2020 16:16:04 GMT

Good day everyone,

to convert this syntax from set analysis to script (during load)

=Count({< Active={1},Location={Canada','*Can*'}>} Distinct EmpNo)-Count({< Terminated={1},Location={'Canada','*Can*'}>} Distinct EmpNo)

- where Active is record tag as active employee, same goes to Terminated (tag)

- Location is a field

- EmpNo is Employee number

syntax is count Emp No if the employee is active and if location is Canada - count if terminated and location is canada

Regards,

Re: from set analysis to script during load

swuehl — Tue, 16 Aug 2016 20:14:33 GMT

It's quite hard to convert a chart expression to an aggregation in the script without knowing the context, i.e. your chart expression will still be sensitive to user selections and also consider the dimensional aggregation scope.

The Aggregation Scope

edit:

If all fields are within the same table and you want to calculate in global context (no selections, no dimensions), maybe something like

LOAD

Count(DISTINCT If(Active=1,EmpNo)) - Count(DISTINCT If(Terminated = 1, EmpNo)) as Result

RESIDENT YourTable

WHERE WildMatch(Location, '*Can*');

Re: from set analysis to script during load

Wed, 24 Aug 2016 04:58:56 GMT

Thanks Stefan,

I will try this solution.

Regards,