Hide Listbox if there are no data for particular month

[retko1985]

Hello,

Here are my data:

When I select Month 6, I want listbox City to disappear. Normally it is:

So how can I check if there are some data in a column for some value of another column?

Attaching QVW also.

Thank you.

[tresesco]

Layout->Conditional Expression: =len(trim(Concat(DISTINCT City)))

[dapostolopoylos · Accepted solution]

I tried a conditional statement in the layout of the ListBox, check the attached file