topic Add column when loading with if in QlikView

Add column when loading with if

Wed, 12 Dec 2012 21:25:54 GMT

I have a column: Otstanding_amount

I would like to add an another column named Status with a script. This column needs to be filled in automatically as follows:

"Outstanding amount to be payed" when the value of Outstanding_amount is not zero

"Payed" when the outstandin amount is zero

Here is my script:

LOAD [Invoice number],

[Total amount],

Outstanding_amount

?????? as Status

FROM

$(My_Path)\Tabel 2.2 Clients.xlsx

(ooxml, embedded labels, table is [xls-1212-140305]);

CELAMBARASAN — Wed, 12 Dec 2012 21:28:26 GMT

Try this

LOAD [Invoice number],

[Total amount],

Outstanding_amount

if(Outstanding_amount <> 0, 'Outstanding amount to be payed', 'Payed') as Status

From

$(My_Path)\Tabel 2.2 Clients.xlsx

(ooxml, embedded labels, table is [xls-1212-140305]);

MayilVahanan — Wed, 12 Dec 2012 21:45:11 GMT

You can also try with match()

LOAD [Invoice number],

[Total amount],

Outstanding_amount

if(Match(Outstanding_amount,0),'Payed','Outstanding amount to be payed') as Status

From

$(My_Path)\Tabel 2.2 Clients.xlsx

(ooxml, embedded labels, table is [xls-1212-140305]);