topic Re: Strings in expression / adding columns in QlikView

Strings in expression / adding columns

zagzebski — Tue, 11 Apr 2017 22:51:59 GMT

Is there a simple way to replace a "0" amount with a string in an expression.

Once the string is in place I assume there is no way to add columns using column names because it won't effectively add columns that have strings in them?

Zag

Re: Strings in expression / adding columns

sunny_talwar — Tue, 11 Apr 2017 23:35:05 GMT

I think you should be able to use RangeSum() which would still sum if one or more columns have numeric value

RangeSum(Column(1), Column(2), Column(3))

If for example, a particular row have

10, NA, 10, the above expression will give you 20