Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table containing user and units. I would like to create a new column in qlik which contains the count of unit. for example user abc and xyz have unit = 1. so count(unit) for both of them would be 2(as unit = 1 occurs two times).
Can anyone help how can I do it ?
@VS2 maybe like ?
input :
measure :
=count(total <unit>user)
output:
@VS2 maybe like ?
input :
measure :
=count(total <unit>user)
output: