Another option might be using a color expression like ColorMix1 and a expression that maps your dimension to a range between 0 and 1:
FieldIndex('YourDimensionField',YourDimensionField) / FieldValueCount('YourDimensionField'),
Adjust the base colors to get a better color range.
I guess the reason for the default colour palette being restricted to 18 colours is that using more colours would make your chart difficult to read. So the best solution IMO would be a drill down group as second dimension:
A (hard to read) solution using precalculated distinct colours however could be:
table1: LOAD *, 'group'&(Div(Mid(YourDim2,8)-1,10)+1) as YourDim2Group; LOAD RecNo() as ID, 'dim1val'&Ceil(Rand()*10) as YourDim1, 'dim2val'&Ceil(Rand()*100) as YourDim2, Ceil(Rand()*100) as YourFact AutoGenerate 1000; tabTemp: LOAD Distinct YourDim2 Resident table1; tabColours: LOAD YourDim2, RGB(Rand()*256,Rand()*256,Rand()*256) as Dim2Colour Resident tabTemp; DROP Table tabTemp;
hope this helps
QlikCommunity_Thread_217974.qvw 195.8 K