I need to perform sorting of dimension on the third dimension in qlikview by using Pivot tables.
IS there a way to do that?
Please let me know if you need any examples.
Pivot tables are very hard to sort. The sorting of second, third etc dimensions will get the same sorting for each value of the 'parent' dimension. The only exception afaik is enabling the sorting by Y-value on the first dimension.
Retrieving data ...