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)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi all, I have a set of data that contains the location of items in a warehouse. As a simplified version:
I can then count the number of times a location is used.
I then want a KPI that shows the number of locations that only have 1 item.
How can I do this in one formula.
Thanks for the help.
You can try this:
if( Aggr( Count([Item no.]) , Location ) = 1 , 1, 0 )
View solution in original post
Hey, you can get the result like this:
Thank you both, either solution seemed to get the answer I was looking for!Much appreciated.