Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all, I have attached the picture, that explains what needs to be done.
I have no idea how to do it.
Thank you for any input
When you bring in the data you can use a where clause where Len(Trim(Location)) > 0 which will filter out the blanks.
Supress values where Location is Null?
When I suppress i get this
When you bring in the data you can use a where clause where Len(Trim(Location)) > 0 which will filter out the blanks.
check out the attachment.
for future reference, please read through this pageQlikCommunity Tip: How to get answers to your post?