Problem with my expression

Tue, 24 Dec 2013 15:40:48 GMT

=trim(concat(distinct {1<[Support Type]={Capability},Capability_Key={Column(1)}>}Supports,chr(13)))

Re: Problem with my expression

stevedark — Tue, 24 Dec 2013 16:56:59 GMT

Hi Christopher,

Can you please give a bit more context about what you are trying to do in this expression?

If this is a chart expression and you are trying to reference a previous column (Column(1)) then I'm afraid that you can not do this in Set Analysis. You will need to repeat the expression in the Set Analysis, perhaps using dollar expansion.

Also, if you are trying to match the text Capability (rather than the value of a field called Capability) then this needs to be in single quotes.

Note as well that the trim statement will trim the whole output (eg. only the start of the first line of text and the end of the last). If you want to trim all of the values you need to trim the Supports field inside the Concat.

You may wind up with something like:

=concat(distinct {1<[Support Type]={'Capability'},Capability_Key={$(=max(Capability_Key))'}>}trim(Supports),chr(13))

The best thing to do with set analysis statements is to start without any Set Analysis and then add in each field at a time to check what it does to the output.

Hope that helps.

Steve

topic Re: Problem with my expression in QlikView

Problem with my expression

Re: Problem with my expression