topic Order a Pivot Table for Expression in QlikView

Order a Pivot Table for Expression

Fri, 14 Aug 2009 00:29:21 GMT

Hello to all

I have a pivot table, and want to order it for volume, descended. I ordered the dimesion chains for expression, descending, in this case SUM(volume), but, when the volume is zero is it at the beginning of the list and not at the end.

Thanks

Order a Pivot Table for Expression

Mon, 17 Aug 2009 16:28:22 GMT

In the pivot chart properties, tab Sort.

Check Expression and select Descending, then in the expression window just below that type in =sum(vol)

regards,
FC

Order a Pivot Table for Expression

Mon, 17 Aug 2009 21:14:59 GMT

Thanks,

The Sum add in the expression, but continuous first the values zeros.

This is the expression:
=num(sum ({$<d_anio = {*}, d_mes = {*}, dia_del_mes = {*}, Fecha_num = {$(vPeriodo)}>} Vol))

Sum the volume for a period of time.

Order a Pivot Table for Expression

Mon, 17 Aug 2009 21:39:00 GMT

In the Dimensions tab of the chart/pivot try to check the box "Surpress when value is Null" in the Settings for selection Dimension