Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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, ', ')
You can use something like Concat(Field,';') Group By DimensionField
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, ', ')
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)
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.
In Chart Properties - Sort - Dimensions - Sort by Expression
=match([Dimension], 'Amber','Black','Bottle','Burgundy')
That works brilliantly..
Thanks for your help guys!