Display Order

[Anonymous]

Hi guys,

A bit of a long shot I've got some data stored by colours in a SQL table like this

Amber

Black

Bottle

Burgundy

Is it possible for Qlikview to display them in a field like this within a table?

Amber, Black, Bottle, Burgundy

I want the colours all in one field as opposed to four fields (as they are above). 

Hopefully this makes sense?

Thanks

[Digvijay_Singh]

You can use something like Concat(Field,';') Group By DimensionField

[swuehl · Accepted solution]

Not sure how your setting looks in more details, but if the four values are located in a single field in data model, you can concatenate the values:

=Concat( ColourField, ', ')

[pokassov]

You can use function Concat() with sort_weight...

For your colour sort you can add field in model that will be number.

Colour, ColourNum

Amber,1

Black,2

Bottle,3

Burgundy,4

then

concat(distinct Colour, ColourNum)

[sunny_talwar]

To continue with the two responses above me, if you want them in a table. Create a table with 1 as dimension and use Concat(ColorField, ',') as an expression.

[#6]

In Chart Properties - Sort - Dimensions - Sort by Expression

=match([Dimension], 'Amber','Black','Bottle','Burgundy')

[Anonymous]

That works brilliantly..

Thanks for your help guys!