This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a table like this :
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.
count(total <Deliverynumber, Position> distinct Serialnumber)
Hope this helps.
View solution in original post