topic Re: Create new data column conditionally to other columns in App Development

Create new data column conditionally to other columns

QlikSensor — Thu, 05 Sep 2019 10:55:20 GMT

Hi,

I have a column in my table which contains only ones and zeros. I need a new column (or the other column replaced) that a certain string is written.

For example, I have following data:

Error

And I need in QlikSense:

Part state

Part is ok

Part is not ok

Part is ok

Is there something I can do during loading the data?

Re: Create new data column conditionally to other columns

mahaveerbiraj — Thu, 05 Sep 2019 11:11:57 GMT

Hi ,

you can try this in load script.

pick(match(Error,0,1),'Part is ok','Part is not ok') as [Part state]

Thanks

Mahaveer

Re: Create new data column conditionally to other columns

erp_curaden — Thu, 05 Sep 2019 11:16:38 GMT

Try the following (I hope I understood you correctly:

Example table:

Tablename: ERROR:

TableColumn: Error:

ErrorStateTable:

Load

ERROR.Error as "ErrorID"

From ERROR;

Left Join

Load * Inline [

'ErrorID', 'ErrorDescription'

0, 'Part is ok'

1, 'Part is not ok'

]

Re: Create new data column conditionally to other columns

QlikSensor — Thu, 05 Sep 2019 12:10:10 GMT

Wow, works great. Thanks for sharing. Just another question: Can I extend the conditional part of the match statement?

I have a column which can have other values as well. E. g.

Error code

I want to accept all error codes except 0 and 1 (note that this is a simple example, actually I have a string and not a number). This should result in:

Error Code Accepted

yes

so something like this:

pick(match(Error,0|1),'no','yes') as [Error Code Acceted]

Re: Create new data column conditionally to other columns

mahaveerbiraj — Thu, 05 Sep 2019 12:15:57 GMT

hi ,

use something like this in load script ,

if([Error code]=0 or [Error code]=1 ,'no','yes') as [Error Code Accepted]