Qlikview Listbox selection

[everest226]

requirement is i have load a excel tables in qlikview it has more then 200 rows , i want to display all row or table as Y so the listbox has only Y and if i select Y it will select all values from another listbox or table.

i am doing this  for easy use in nprinting filter field selection rather then selecting all name from list box i want to only select Y which will reflect all names

gwassenaar‌

@mohanrao

thanks

[robert_mika · Accepted solution]

Try:

if( Not isNull(Yourfield),'Y') as Ylistbox

[everest226]

Thanks robert_mika‌

I tried

load ------------ AS User,

'Y' as flg

FROM tablename

[#4]

everest226‌ it works