topic Button to sort a field in QlikView

Button to sort a field

tinkerz1 — Thu, 09 Jul 2015 10:22:04 GMT

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.

Re: Button to sort a field

tyagishaila — Thu, 09 Jul 2015 10:26:15 GMT

Hi,

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

Re: Button to sort a field

giakoum — Thu, 09 Jul 2015 10:27:44 GMT

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

Re: Button to sort a field

ashfaq_haseeb — Thu, 09 Jul 2015 10:28:31 GMT

Hi,

Check below, this should help you.

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

Regards

ASHFAQ

Re: Button to sort a field

brian_booden — Thu, 09 Jul 2015 10:30:19 GMT

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

Re: Button to sort a field

awhitfield — Thu, 09 Jul 2015 11:57:38 GMT

Hi Neil,

any chance that you could upload an example qvw?

Andy

Re: Button to sort a field

tinkerz1 — Thu, 09 Jul 2015 13:36:16 GMT

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