topic Sorting Expressions in QlikView

Sorting Expressions

Mon, 15 Oct 2012 18:11:16 GMT

I have a chart with many expressions. Whenever I add a new expression, I press the "Promote" button many times to get the expression to show in the order I would like. Is there an easier way to do this, like some kind of drag and drop, or any other way that I can sort the chart expressions without having to press the promote and demote buttons repeatedly? Or a way to select multple expressions so I can move them all up or down at the same time?

Re: Sorting Expressions

Gysbert_Wassenaar — Mon, 15 Oct 2012 18:18:08 GMT

On the Expressions tab you can drag and drop them, but not on the Sort tab. It's a bit bothersome sometimes with large numbers of expressions, but manageable since I rarely need more than six in a table. And I can rearange the table by dragging and dropping columns directly in the table.

Re: Sorting Expressions

MayilVahanan — Mon, 15 Oct 2012 18:23:52 GMT

In straight table , in sort tab -> select Allow Interactive sort. And click ok.. You can use click the header of the expression its sort ascending or descending ways..

Hope it helps

Re: Sorting Expressions

Fri, 19 Oct 2012 19:01:03 GMT

Thanks everyone. I figured this was the case. I did find that I could hold down ALT + P after selecting the expression and it would move it up or down faster than having to click repeatedly.

The reason I asked is because I use a dynamic pivot table where users choose which dimensions and expressions to see, which requires me to have a lot (~100) expressions in one pivot table.