topic Re: Sorting in Pivot table in QlikView

Sorting in Pivot table

Tue, 31 Mar 2015 09:59:48 GMT

Guys,

I have a pivot table like :

I need to sort this table like 1 hour, 2 hours, 4 hours, 1 day......, 1 week....., 1 month etc.

I tied like numeric sort and text sort, but it doesnt give me the desired result.

Any ideas?

Re: Sorting in Pivot table

robert_mika — Tue, 31 Mar 2015 10:27:55 GMT

Could you attached your file?

Re: Sorting in Pivot table

rubenmarin — Tue, 31 Mar 2015 10:29:28 GMT

Hi Diana, you can use Dual() function when you're creating your Period values, this way you can sort Period dimension by number.

In example:

If(Minutes<60, Dual('1 hour', 1),

If(Minutes <120, Dual('2 hours', 2),

If(Minutes <240, Dual('4 hours', 3)... and so on.

Re: Sorting in Pivot table

Tue, 31 Mar 2015 10:36:14 GMT

I've solved this problem using : =match([Period],'1 hour','2 hours','4 hours','6 hours','1 day', '2 days', '3 days', '4 days','1 week', '2 weeks', '3 weeks', '1 month', '2 months', '3 months')

in sort---> Expression