Button to sort a field

[tinkerz1]

Hi,

I am looking for a button object to sort a field by A-Z and then another field by A-Z.

So I can give the user some sort options by button.

But I do not see any actions in the button object.

Whats the easiest way to do it without macros?

Thanks.

[tyagishaila]

Hi,

User can sort field values A-->Z or Z-->A  by double clicking on field name (Dimension/Expression).

[giakoum]

what kind of object do you want to sort Neil?

Straight tables are sorted easily by column, but pivot is a different story

You can also use a variable to sort (by setting the sorting via the button) but this depends on the case

[ashfaq_haseeb]

Hi,

Check below, this should help you.

https://community.qlik.com/docs/DOC-7220

Regards

ASHFAQ

[brian_booden]

Hi Neil,

Are you talking about a list box here? 

If so, a way to do it is to have several listboxes layered on top of each other (each with a different sort order) with the Show Conditional option being utilised.  Use variables to determine which listbox should be shown at any one time.

Alternatively, you could use one list box, and use sort by expression in the Sort tab.  Make the expression a variable and change the way it sorts based on when you push a button.

Hope that helps.

Regards,

Brian

[awhitfield]

Hi Neil,

any chance that you could upload an example qvw?

Andy

[tinkerz1]

Its ok, double clicking the column header will do

Although I am surprised is no custom sort action to st for a button.

Where you can sort be 2 or more columns