topic Re: interactive sort in QlikView

interactive sort

adiarnon — Mon, 08 Aug 2016 12:37:59 GMT

hi i have this table,

its a pivot table

my user want to be able to sort the table by interactive sort.

do i have another solution then to make a streight table and to define each column by set analysis with his own month?

thx,

adi

adamdavi3s — Mon, 08 Aug 2016 13:44:58 GMT

I've had a similar issue before and you can write a macro and use a clear textbox as a 'button' to call the macro to sort the table.

Not ideal but it does work depending how you want to do the sorting.

adiarnon — Mon, 08 Aug 2016 14:53:55 GMT

tnx,

we are working with the IE Plugin

we tried to work with macro but its not working good

any other options?

settu_periasamy — Mon, 08 Aug 2016 15:25:32 GMT

Hi,

antoniotiman — Mon, 08 Aug 2016 15:45:20 GMT

Hi Adi,

You can use in Sort an expression like this

Sum({<Month={$(=vSort)}>} Value)

vSort is variable in InputBox

See attachment

Regards,

Antonio