Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Aggregated functions sum another dimension only distinct

Aggregated functions sum another dimension only distinct

Hello,

I have a table like this :

 

SerialnumberTimestampPositionDeliverynumber
BF3333306.05.20201011111111
BF3333406.05.20201011111111
BF3333506.05.20201011111111
BF3333606.05.20202011111111
BF3333706.05.20202022222222
BF3333807.05.20203033333333
BF3333907.05.20203033333333
BF3334007.05.20203033333333
BF3334107.05.20203033333333
BF3334207.05.20203033333333

 

The Serialnumber is unique, a delivery can contain more than one serialnumber and a serialnumber can belongs always to a group of position. Also the date of the package can be on two different days.

I now just want to add a colllumn  with the   measure where I can see in each line how many Serialnumbers a specific delivery contains.  The date can be disregarded.

I used something like this:

=sum(aggr(count([Meldung-Serialnumber]), [Deliverynumber], Position))

But since there are many positions, i only want to count each of the position distinct. 

And something like this doesn't work out: 

=sum(aggr(count([Meldung-Serialnumber]), [Deliverynumber], distinct Position))

How can I only count this aggregation with the same Position distinct?

Thanks in advance.

Best. 

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

try this:

count(total <Deliverynumber, Position> distinct Serialnumber)

 

Hope this helps.

View solution in original post

1 Reply
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

try this:

count(total <Deliverynumber, Position> distinct Serialnumber)

 

Hope this helps.