topic Re: How can I format filter list items in QlikView

How can I format filter list items

Tue, 21 May 2013 11:23:49 GMT

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?

Re: How can I format filter list items

sushil353 — Tue, 21 May 2013 11:28:06 GMT

go to property of listbox

General tab>field>experssion

and put if condition:

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

PFA

HTH

Sushil

Re: How can I format filter list items

Tue, 21 May 2013 11:34:54 GMT

Hi kumar ,

But it shows list as

"1 Yes"

"0 No"

how to hide this code from above string.

Re: How can I format filter list items

Tue, 21 May 2013 11:37:32 GMT

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

Re: How can I format filter list items

sushil353 — Tue, 21 May 2013 11:38:01 GMT

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...

Re: How can I format filter list items

Tue, 21 May 2013 12:05:11 GMT

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"??

Re: How can I format filter list items

kumarnatarajan — Tue, 21 May 2013 12:09:53 GMT

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
];

Re: How can I format filter list items

Tue, 21 May 2013 12:12:15 GMT

Hi ,

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

Re: How can I format filter list items

kumarnatarajan — Tue, 21 May 2013 12:22:51 GMT

Hi,

I think some other way is not Possible.