Help with chat

[#1]

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

[ThornOfCrowns]

Supress values where Location is Null?

[#3]

When I suppress i get this

[jpapador · Accepted solution]

When you bring in the data you can use a where clause where Len(Trim(Location)) > 0 which will filter out the blanks.

[Anonymous]

check out the attachment.

for future reference, please read through this pageQlikCommunity Tip: How to get answers to your post?