sql to qlikview script?

[manoranjan_d]

how to do this?

how to do this

select (CASE WHEN ((field1 IS NOT NULL) OR (field2 IS NOT NULL)) THENISNULL(field1 ,'') + ', ' +

ISNULL(field2,'') ELSE field3 END) AS xxxx from table;

[Anil_Babu_Samineni]

First part this?

If(Len(Trim(field1))=0 or Len(Trim(field2))=0, IsNull(field1),' ')

[manoranjan_d]

we should concatenate the field1 and field 2

but there is  no concatenation happened

[Anil_Babu_Samineni]

Will you able to explain Business?

[Peter_Cammaert]

Something like this?

...IF (IsNull(field1) and IsNull(field2), field3,

                                          field1 & ', ' & field2) AS xxxx

[prma7799]

how to implement the sql decimal() and round() in to the qlikview and

????