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
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 pageQlik Community Tip: How to Get Answers to Your Post
Retrieving data ...