topic Re: Display Order in QlikView

Display Order

Anonymous — Thu, 01 Oct 2015 16:05:43 GMT

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

Re: Display Order

Digvijay_Singh — Thu, 01 Oct 2015 16:10:02 GMT

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

Re: Display Order

swuehl — Thu, 01 Oct 2015 16:10:26 GMT

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, ', ')

Re: Display Order

pokassov — Thu, 01 Oct 2015 16:12:53 GMT

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)

Re: Display Order

sunny_talwar — Thu, 01 Oct 2015 16:14:08 GMT

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.

Re: Display Order

Fri, 02 Oct 2015 05:14:37 GMT

In Chart Properties - Sort - Dimensions - Sort by Expression

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

Re: Display Order

Anonymous — Fri, 02 Oct 2015 08:39:38 GMT

That works brilliantly..

Thanks for your help guys!