Achieve Interactive sort in expression.

[#1]

Hi all,

how can i acheive interactive sort Using Expression. i want the expression which does Interactive sort.If i do sort, its getting sorted based on previous dimension.But i want sort to happen independantly.

Thanks

Ganesh

[ashfaq_haseeb]

Hi,

Check if this helps

http://community.qlik.com/message/617913#617913

Regards

ASHFAQ

[#3]

Hi ashfaq

Thanks for your reply, but i want to sort multiple dimensions!! this one doesnt solave my problem.

Thanks

Ganesh

[Anonymous]

Hi Ganesh,

Please go through the following link.

Sorting in Ascending Order by Using Expression in QlikView

Hope it helps.

Thanks & Regards,

Geeta

[ashfaq_haseeb]

Hi,

Can you provide some sample data with expected o/p.

What chart type you use?

Interactive sort is available in Straight table not in pivot.

Regards

ASHFAQ

[#6]

Hi

I want to achieve sorting on this button, i have already tried Macro and it does sorting based on previous Dimension only, and also Macros dont work in our Server.

I want to achieve interactive sort in this button.is there any way to do intearctive sort using Expression??

Thanks

Ganesh

[#7]

Ashfaq Mohammed

Does it make sense?
Can you help me out?

Thanks in advance

Ganesh

[ashfaq_haseeb]

Hi,

What chart type you use?

By default you can have interactive sort in straight table.

If you use pivot table then try to switch it to Straight table.

Regards

ASHFAQ

[#9]

Hi Geetha,

I want to achieve sorting on this button, i have already tried Macro and it does sorting based on previous Dimension only, and also Macros dont work in our Server.

I want to achieve interactive sort in this button.is there any way to do intearctive sort using Expression??

Thanks

Ganesh

[giakoum]

If you want to sort multiple dimensions by expression then the only way to do so is in a straight table in the sort tab for every expression :