Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Brian, can you upload an application example?