topic Re: Manual Sort By User in QlikView

Manual Sort By User

marleygt — Tue, 22 Dec 2015 09:53:20 GMT

Hi all.

I have a pivot table with several dimensions.

Sort is made by Customers Name in first Dimension/column(with Alphabetical order from A to Z).

Is there a way to let user change order if needed, for instance, sorting sales column? (from major to minor).

And if is this possible, may I perform this also for another column (in this case "Last Month" column)?

(I mean, is possible to create multiple-field filter's button?)

Thank you for any suggestion and help!

Alex

Re: Manual Sort By User

Tue, 22 Dec 2015 09:55:57 GMT

Hi Alex,

If the user double-clicks the column name that he/she wants sorted by, the column will auto-sort by the selected column.

Janine

Re: Manual Sort By User

NareshGuntur — Tue, 22 Dec 2015 10:11:04 GMT

Hi Alex,

It is possible.

Check 'Allow Interactive Sort' under Sort tab in Chart properties.

User can double click on any of the Field label and the sort will automatically change taking that field as priority.

Note: This option should be checked for all the columns which user want to sort on.

Cheers,

Naresh

Re: Manual Sort By User

marcus_sommer — Tue, 22 Dec 2015 10:15:03 GMT

The easiest way to enable sorting to the users is to change the chart-type to a straight-table by which the user could sort the columns by double-clicking on the column-header.

To enable a inter-active sorting by a pivot is more difficult. Possible are sorting-expressions which catch the user-selection on a field or a variable but especially if there are more then one column/metric it will be complicated. Easier might be to use several identical dimensions/expressions unless different sorting-options and whose visibility will be controlled by conditions (also triggered by selections or variables).

Very helpful is this link Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level) especially if there are many dimensions involved.

- Marcus

Re: Manual Sort By User

marleygt — Tue, 22 Dec 2015 10:23:35 GMT

Thank you NareshGuntur for your reply.

Unfortunately is a straight table feature only...

Thank you Marcus_Sommer too.

I already read that discussion...I was hoping in a easier way...

However, I will take a second better and deeper look at the discussion you suggest.

I have more then 7 dimensions, but should be enough filtering for 2 at least.

Thank you anyway both.

Alex

Re: Manual Sort By User

marleygt — Tue, 22 Dec 2015 11:09:15 GMT

Hi JanineCo‌, Thanks to you also for you reply.

Unfortunately I could do this only in Straight table.

Thx anyway!