topic Re: Double records in the Expression Part in QlikView

Double records in the Expression Part

Learnerr — Tue, 08 Feb 2022 06:41:19 GMT

Hi,

I made a table in the front part.

My colums are names,training names,teacher name and my expression is the sum(time) of the education.

The problem is: Some participants took the education from different teacher so the time comes double for those people. How can i make a sepaeration to say that take only 1 teavher for a 1 participant.

Thanks.

Re: Double records in the Expression Part

tresB — Tue, 08 Feb 2022 07:13:35 GMT

Try: Sum(Distinct Time)

Re: Double records in the Expression Part

Learnerr — Tue, 08 Feb 2022 07:16:42 GMT

Yes but i would like to say sum(time) when my dimension"unique teacher"

Re: Double records in the Expression Part

Learnerr — Tue, 08 Feb 2022 07:17:38 GMT

Because some students take same education from different tutors. I would like to say sum(time) when my dimension is a distinct teacher

Re: Double records in the Expression Part

tresB — Tue, 08 Feb 2022 07:22:38 GMT

Since teacher is one of your dimensions, it should work fine. If not, try to explain with an example.

Re: Double records in the Expression Part

Learnerr — Tue, 08 Feb 2022 07:26:45 GMT

In simply how can i write this in the expression part:

One of my dimension: Teacher

Expression: Sum(Time)

I would like to say that sum(time) when Teacher is unique.(distinct)

Re: Double records in the Expression Part

tresB — Tue, 08 Feb 2022 08:02:39 GMT

I am not sure if I understood right, to avoid other dimensions impact - you could right an expression like:

Aggr(Sum(Distinct Time), Teacher)

Re: Double records in the Expression Part

Learnerr — Tue, 08 Feb 2022 08:38:52 GMT

With this table i tried to explain:

I extract data from SAP. Some participants is recorded to sap that took a training from 2 tutors. I would like to say while calculating sum (time) tell me only the time from a single tutor for a participant.