Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
mandilicious
Creator II
Creator II

How to ignore some values in listbox

Hi All

Please help i need to ignore numbers and only display countries in my list box.

I  don't  want to see 100,101,102,103. i  only want  Ghana,INDIA,UK in my list box.

Countries.PNG

Thanks

1 Solution

Accepted Solutions
tresesco
MVP
MVP

If(Not IsNum(Country), Country)  .. then enable 'suppress when value is null'

Or for specific names:

If(Match(Country, 'Ghana', 'INDIA, 'UK'), Country)

View solution in original post

8 Replies
tresesco
MVP
MVP

If(Not IsNum(Country), Country)  .. then enable 'suppress when value is null'

Or for specific names:

If(Match(Country, 'Ghana', 'INDIA, 'UK'), Country)

View solution in original post

ogautier62
Specialist II
Specialist II

Hi,

something like this should work :

choose expression and then :

=only({<Countries = {"=not(isNum(Countries))"} >}Countries)

regards

dapostolopoylos
Creator III
Creator III

You can use an approach like the one i included in this app:

Father/Husband/BI Developer
PrashantSangle

where you want to do ? in front end or in back ends?

try with string function like purgechar() or keepchar().

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
mandilicious
Creator II
Creator II

Hi Tresesco

Brilliant it worked like a charm thank you very much.

mandilicious
Creator II
Creator II

Thanks Dimitrios it is worked  as well,I chose Tresesco solution but thank you very very much i really appreciate you help.

mandilicious
Creator II
Creator II

Thank you very much it is worked as well,just that i I chose Tresesco solution but thank you very very much i really appreciate you help.

mandilicious
Creator II
Creator II

Hi Tresesco

Brilliant it worked like a charm thank you very much.