Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help with chat

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

1 Solution

Accepted Solutions
jpapador
Valued Contributor

Re: Help with chat

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

4 Replies
thornofcrowns
Valued Contributor II

Re: Help with chat

Supress values where Location is Null?

Not applicable

Re: Re: Help with chat

When I suppress i get this

jpapador
Valued Contributor

Re: Help with chat

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

jsaradhi
Valued Contributor

Re: Help with chat

check out the attachment.

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

Community Browser