Problems sorting a pivot table

bronsonelliott — Fri, 18 Jul 2014 21:47:28 GMT

I hope someone can help. I'm trying to sort a pivot table and it's giving me fits!!!

I'm pulling some data from a database. Included in this data is a sort field called 'Sort'. This field is a numeric field.

I have a pivot table using the data from this database and I want to sort the data by the 'Sort' field but I don't want to show the sort field. So I thought I could use a n expression to do this but I'm getting some inconsistent results.

If you see in the screen shot, I've included the Sort field just to visualize what's going on. I have the sort expression of sum(Sort) on the "Section", "Grouping" and "Metric" fields but it's still acting weird. I've tried different combinations of using the expression on only 1 field but I still get inconsistent results.

Please help!!

Re: Problems sorting a pivot table

bronsonelliott — Fri, 18 Jul 2014 22:49:05 GMT

I may have figured it out. I tried using Max(Sort) and it seems to be working. Not sure why so if anyone wants to chime in please do so.

topic Problems sorting a pivot table in QlikView

Problems sorting a pivot table

Re: Problems sorting a pivot table