topic Re: sql to qlikview script? in QlikView

sql to qlikview script?

manoranjan_d — Thu, 22 Jun 2017 09:32:00 GMT

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 — Thu, 22 Jun 2017 09:38:39 GMT

First part this?

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

manoranjan_d — Thu, 22 Jun 2017 09:40:56 GMT

we should concatenate the field1 and field 2

but there is no concatenation happened

Anil_Babu_Samineni — Thu, 22 Jun 2017 09:42:08 GMT

Will you able to explain Business?

Peter_Cammaert — Thu, 22 Jun 2017 09:43:06 GMT

Something like this?

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

field1 & ', ' & field2) AS xxxx

prma7799 — Thu, 22 Jun 2017 09:44:10 GMT

????