I've got a chart that I'm happy with, that displays the cumulative percentage of a variable across the dimension:
Variable is count(ID)/count(total <Dimension1> ID) with Accumulation set to full accumulation.
My problem comes if I try to build a trellis on Dimension2: I get this:
I'm rather unclear what I should do to make it behave nicely within the trellis - the cumulative increases don't seem to be working any more (look at eg B2, where the distribution looks normal when it should be strictly increasing)
The only odd thing is that on my client (QV11) John's script for generating an AsOf table didn't work. I've duplicated the script from here http://community.qlik.com/message/89017#89017 and it only works if I add a second dimension with the same values into the load. Any ideas why?
(ooxml, embedded labels, table is Sheet1);
LOAD DISTINCT Dimension, Dimension AS Dimension1
LEFT JOIN (AsOf)
LOAD Dimension1 as AsOfDimension1
INNER JOIN (AsOf)
,if(AsOfDimension1=Dimension1,'Current','AllPrevious') as Dimension1Type