Changing the format

[#1]

Hi All,

  I have a column name by installed under which values are 0 and 1 , So when iam fetching the data in qlickview  i want to represent in table a  Yes for 1 and No for 0 , how can i make this into Edit Script , Becuase in dashboard i have to present the value as a straight table ,  under the column installed where it should show instead of 0 ans 1  as Yes and no ,

Thanks In Advance

[alexandros17]

When you load data:

LOAD

...

if(myField='1', 'YES', 'NO') as myField

....

Let me know

[its_anandrjs]

Try like

Load

installed,   //i assume it is field with values 1 and 0.

If(installed = 1,'Yes','No' ) as Detail_installed

From Location;

Ex:-

Load  installed, If(installed = 1,'Yes','No' ) as Detail_installed;

Load * inline

[

installed

1

1

1

0

1

0

];

[Anonymous]

Hi,

Try below,

If(installed=1, 'Yes', If(installed=0, 'No', 'NA')) as installed

[sasikanth]

hi

Try like below

LOAD
if(column='1','YES',column='0','NO') as column,

.

.

.

From ....................table

[jonathandienst]

Hi

If you create dual values for Yes/1 and No/0, then you can store a countable value (1 or 0) and a Yes/No format in the same field. So something like this based on a field [column]:

     LOAD

          If([column], Dual('Yes', 1), Dual('No', 0)) As [column],

Now you can Sum(column) to get a count or use Only(column) or dimension to display Yes/No.

HTH

Jonathan