Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How can I format filter list items

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?

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: How can I format filter list items

go to property of listbox

General tab>field>experssion

and put if condition:

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

PFA

HTH

Sushil

8 Replies
sushil353
Honored Contributor II

Re: How can I format filter list items

go to property of listbox

General tab>field>experssion

and put if condition:

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

PFA

HTH

Sushil

Not applicable

Re: How can I format filter list items

Hi kumar ,

But it shows list as

"1 Yes"

"0 No"

how to hide this code from above string.

Not applicable

Re: How can I format filter list items

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

sushil353
Honored Contributor II

Re: How can I format filter list items

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

Not applicable

Re: How can I format filter list items

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
Valued Contributor

Re: How can I format filter list items

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

Not applicable

Re: How can I format filter list items

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
Valued Contributor

Re: How can I format filter list items

Hi,

I think some other way is not Possible.

Community Browser