i have following Data Displayed in a List box -
i want list box to show rows which is having matching substring as 'ND'
in this case -
Can Any one assist how to do that, i am new to qlikview.
The easiest is to search in the listbox and use *ND* as search string.
If you always want to show only the countries with ND then try an expression like =if(Country like '*ND*', Country).
i do not want the other values to be displayed in the list box at all until the substring 'ND' exists.
Until the substring exists? Would be able to elaborate?
yes, Until the substring exists, do not show in the list box.
Based on the selections it exists or based on its availability in the application?
Based on all the available occurrences with 'ND' as subfield
Retrieving data ...