topic Sort data (with hidden dimension) in QlikView

Sort data (with hidden dimension)

Mon, 01 Feb 2010 15:54:54 GMT

Hi,

Is it possible to sort data in reports with dimension that I don't want to show? I'm using version 8.5.

Sort data (with hidden dimension)

Mon, 01 Feb 2010 16:03:19 GMT

Not sure if this is what your after but you can sort your data by an expression. Go to chart properties->Sort and check the Sort by expression checkbox. Then write whatever expression you like. It will be evaluated over the dimensions in your chart and the chart will be sorted by the expression result.

/Fredrik

Sort data (with hidden dimension)

Wed, 03 Feb 2010 08:04:54 GMT

Thanks for quick reply, it works now!

Re: Sort data (with hidden dimension)

jmcdermott — Wed, 19 Sep 2018 14:54:30 GMT

Thanks this answered my questions.