Reorder dimensions in block chart

[#1]

Hello,

I'm new here so sorry in advance for protocol errors. Grateful if anyone can help me with this.

I have a Block Chart, which splits my data set into 3 dimensions. Let's call them:

- Clinical Specialty

- PatientMode

- PatientFunder

The dimensions are ranked this way and It's a pretty chart.

I can re-order the dimensions in the block chart by promoting/demoting in ChartProperties->Dimensions and that makes a different chart that's pretty too.

However, I would like my end user to be able to reorder the dimensions once the worksheet is locked.

I've searched Google and this forum but can't find an answer. Have tried variables and calculated dimensins but I'm not sure what I'm doing. Any ideas?

Thanks,

[goldnejea8]

Check out the Whats New in QlikView 11 application.  They have a Reports tab that generates a pivot table based on user's selections.  You could do something like this except have it be a chart and not a pivot table.