topic accessing text field by set analysis in QlikView

accessing text field by set analysis

Wed, 13 Jun 2012 19:06:18 GMT

hi all

I am trying to access a field which contains text by following expression for specific dimension but unable to get the text instead it is showing 0

sum( {$<END_DT={'4/30/2009'}>}(CD_UNIT))

CD_UNIT field contains texts like kwh or kvh or kw etc.

Any solutions to it ?

Re: accessing text field by set analysis

Anonymous — Wed, 13 Jun 2012 22:20:18 GMT

You do not want to use a sum() aggregation against a text field. Instead use Only(), minstring(), maxstring(), or something similar. If you need to display more than one value, look into concat().
-Phil

Re: accessing text field by set analysis

erichshiino — Thu, 14 Jun 2012 00:50:09 GMT

I agree with Phil but if you meant that in the field there are numbers with the unit in a string format, you will need to adjust it to make it a number.

For example

CD_UNIT = '500 W', '500 kW'

You would need to convert it to the same unit in script:

VALUE = 500, 500000 / UNIT = 'W'

Then, you would be able to sum it with your expression

Hope this helps,

Erich