Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
go to property of listbox
General tab>field>experssion
and put if condition:
if(field=1,'Yes','No')
PFA
HTH
Sushil
go to property of listbox
General tab>field>experssion
and put if condition:
if(field=1,'Yes','No')
PFA
HTH
Sushil
Hi kumar ,
But it shows list as
"1 Yes"
"0 No"
how to hide this code from above string.
Sorry its fine now , previously i wrote that in new expression in expression tab. Thanks kumar for your kind help...
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...
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"??
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
];
Hi ,
For this I have to relaod data which takes almost 45 mins I dont want to do that , Is not there another way?
Hi,
I think some other way is not Possible.