topic Re: sorting in a pivottable in QlikView

sorting in a pivottable

Wed, 15 Feb 2012 12:26:55 GMT

Hi,

Having problem with sorting in a pivottable, i am choosing sort by load order (origin) but it still having the column sorted in ascending numeriv value see picture below. the data is not loaded in this way, any suggestions?

Re: sorting in a pivottable

v_iyyappan — Wed, 15 Feb 2012 12:28:58 GMT

hi,

do u sort the data expression based means set the Y Value as 'Ascending Order' in Sorting tab.

(OR)

You sort the value dimension based means Numeric value as 'Ascending Order'.

Regards,

Iyyappan

sorting in a pivottable

Wed, 15 Feb 2012 12:32:31 GMT

unfortenaly i am not able to share the aplication, the data is not loaded in numeric order so i wonder why i cant sort it the way it is loaded from the excel file? in the example picture above it should be ordered 31, 21, 29 i.e. the way it is loaded.

Re: sorting in a pivottable

v_iyyappan — Wed, 15 Feb 2012 12:41:57 GMT

Hi,

I attach a sample file. Please refer it.

Regards,

Iyyappan.

Re: sorting in a pivottable

Wed, 15 Feb 2012 12:45:34 GMT

thanks for your reply, my table is a pivottable and the data i want to sum is loaded data, is this working in a similar way

Re: sorting in a pivottable

v_iyyappan — Wed, 15 Feb 2012 12:53:59 GMT

Hi,

Just change the Chart Type as Pivot table in General tab.

Regards,

Iyyappan.