topic Re: Report Printing - Sort Order in QlikView

Report Printing - Sort Order

Thu, 23 Jan 2014 15:06:06 GMT

Hi,

I have a pivot chart that is displayed correctly with specified sort orders on some of the dimension. However, when this is printed in a report - some of the sort orders aren't matching the screen display.

Is this a common bug within QV 11?

Many thanks,

Tom

Re: Report Printing - Sort Order

Anonymous — Thu, 23 Jan 2014 16:48:50 GMT

Tom,

Can you verify that the pivot table shown on the screen is the same that is used in the report? Check object ID to make sure.

Regards,

Michael

Re: Report Printing - Sort Order

Fri, 24 Jan 2014 09:35:17 GMT

HI,

Yes the chart objects are both the same.

Thanks,

Tom

Re: Report Printing - Sort Order

Anonymous — Fri, 24 Jan 2014 15:09:35 GMT

Can you upload an example?

Re: Report Printing - Sort Order

Tue, 28 Jan 2014 09:23:27 GMT

HI I cant really post an example.

I have over 300 indicators that I need to sort in a particular order that are split into 3 categories :

Tab
Tab_Group
Tab_Sub_Group

In the 'Sort' tab I have tried to sort each Dimension using the following fields

Tab_Order (main category sort order which holds values 1-5)
Tab_Group_Order - which is the second sort column
Tab_Sub_Group_Order - final sort order column.

In my pivot table I am also sorting the Month-Year (which is used horizontally across the top of the pivot).

What ever I try to do the Pivot doesn't sort correctly...

Hope this helps.

Tom

Re: Report Printing - Sort Order

Anonymous — Tue, 28 Jan 2014 14:13:00 GMT

Tom,

Without an example, I can only answer your question in the opening post:
I've never seen a situation where an object in a printed report has different sort order than the same object on the screen. Nor in QV 11 neither in any other version.

From your latest reply, it looks like there are problems with sort order on the screen as well. Pivot tables are not flexible when it comes to sort order. Basically, it sorts in order of dimensions. If you cannot upload an example - search forum for "pivot table sort", you'll definitely find a lot of workarounds for the different specific situations..

Regards,

Michael

Re: Report Printing - Sort Order

ashwanin — Tue, 28 Jan 2014 14:24:37 GMT

Check whether the sort order is working fine in QV object?

Problem is only with report or is it with when you send data into excel als