Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
retko1985
Contributor II

Hide Listbox if there are no data for particular month

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.

1 Solution

Accepted Solutions
dapostolopoylos
Contributor III

Re: Hide Listbox if there are no data for particular month

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

Father/Husband/BI Developer

View solution in original post

2 Replies
MVP
MVP

Re: Hide Listbox if there are no data for particular month

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

dapostolopoylos
Contributor III

Re: Hide Listbox if there are no data for particular month

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

Father/Husband/BI Developer

View solution in original post