how to display a text column in the expressions tab of a straight table

[b_garside]

I have a simple problem it seems. But not sure how I can get around it.

I have some text that I need to display in the expression portion rather than the Dimension.

The reason is the grouping or aggregation is controlled by the Dimensions which can only be three fields in this report. If I add others it drastically changes my output.

If I display them in the Expression portion then the output works correctly.

My hang up is when I try to display text it only displays sparse rows.

Is Min/MaxString correct?

Normally this would be populated.

[Anonymous]

Brian

If you just put a Field Name into an expression then QlikView by default applies the Only() function to it, that will display Null() if there is more the 1 value.

If you want to display them all them you could use the Concat() function

    concat( [Title], ';' )

Best Regards,     Bill

[Anonymous]

Brian, can you upload an application example?