How can I format filter list items

[#1]

Hi every one ,

I have a list named "Adult" there are two items in it 1 and 0 , what I want is to display Yes in place of 1 and No in place of 0 . Can I do that in qlikview?

[sushil353 · Accepted solution]

go to property of listbox

General tab>field>experssion

and put if condition:

if(field=1,'Yes','No')

PFA

HTH

Sushil

[#3]

Hi kumar ,

But it shows list as

"1 Yes"

"0 No"

how to hide this code from above string.

[#4]

Sorry its fine now , previously i wrote that in new expression in expression tab. Thanks kumar for your kind help...

[sushil353]

have u check the application attached... are u adding an extra expression?

check in General tab>field>experssion

if you still have issue then post the sample app...

[#6]

Kumar I need another favour , when I select "Yes" then in current selection box it appears as "1". How can I make that box to show "Yes"??

[kumarnatarajan]

Hi,

You can able to change to load script. See below mentioned syntex.

Ex:

load

*,if(test=1,'Yes','No') as testnew Inline
[
test
1
0
];

[#8]

Hi ,

For this I have to relaod data which takes almost 45 mins I dont want to do that , Is not there another way?

[kumarnatarajan]

Hi,

I think some other way is not Possible.