topic Re: Changing the format in QlikView

Changing the format

Thu, 10 Jul 2014 06:40:47 GMT

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

Re: Changing the format

alexandros17 — Thu, 10 Jul 2014 06:43:08 GMT

When you load data:

LOAD

...

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

....

Let me know

Re: Changing the format

its_anandrjs — Thu, 10 Jul 2014 06:44:02 GMT

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

];

Re: Changing the format

Anonymous — Thu, 10 Jul 2014 06:44:12 GMT

Hi,

Try below,

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

Re: Changing the format

sasikanth — Thu, 10 Jul 2014 06:44:39 GMT

Try like below

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

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

Re: Changing the format

jonathandienst — Thu, 10 Jul 2014 07:06:05 GMT

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