topic Re: Achieve Interactive sort in expression. in QlikView

Achieve Interactive sort in expression.

Tue, 30 Sep 2014 10:50:50 GMT

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

Re: Achieve Interactive sort in expression.

ashfaq_haseeb — Tue, 30 Sep 2014 10:57:59 GMT

Hi,

Check if this helps

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

Regards

ASHFAQ

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:00:50 GMT

Hi ashfaq

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

Thanks

Ganesh

Re: Achieve Interactive sort in expression.

Anonymous — Tue, 30 Sep 2014 11:03:39 GMT

Hi Ganesh,

Please go through the following link.

Sorting in Ascending Order by Using Expression in QlikView

Hope it helps.

Thanks & Regards,

Geeta

Re: Achieve Interactive sort in expression.

ashfaq_haseeb — Tue, 30 Sep 2014 11:04:18 GMT

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

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:09:32 GMT

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

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:23:06 GMT

Ashfaq Mohammed

Does it make sense?
Can you help me out?

Thanks in advance

Ganesh

Re: Achieve Interactive sort in expression.

ashfaq_haseeb — Tue, 30 Sep 2014 11:25:40 GMT

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

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:26:14 GMT

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

Re: Achieve Interactive sort in expression.

giakoum — Tue, 30 Sep 2014 11:28:17 GMT

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 :

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:30:06 GMT

But the problem is When i Sort the second Dimension, I gets Sorted based on the First dimension, I think this is because of the priority settings in Sort tab.Any idea to override that??

Re: Achieve Interactive sort in expression.

giakoum — Tue, 30 Sep 2014 11:32:06 GMT

you define the order in design and disable Allow interactive sorting from the sort tab so that the user cannot change it

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:32:33 GMT

I am using Straight table, but the requirement is- without double clicking on the dimension i want to achieve interactive sort.Any idea on that??

Tahnks
Ganesh

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:35:18 GMT

But it should be the way users wants to sort, so I want to achieve sort in single button click.

Re: Achieve Interactive sort in expression.

ashfaq_haseeb — Tue, 30 Sep 2014 11:37:37 GMT

I don't think that is possible with single click.

Regards

ASHFAQ

Re: Achieve Interactive sort in expression.

giakoum — Tue, 30 Sep 2014 11:38:47 GMT

how do you plan to do that? How will the user define the order?

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:44:46 GMT

Like user can double click on the dimension and sort anyway, i want to do the sort on single button click.is it possible??

Re: Achieve Interactive sort in expression.

Tue, 30 Sep 2014 11:46:05 GMT

Like in Excel we get a prompt like "Expand Selection" while we try to sort a single column.

Re: Achieve Interactive sort in expression.

giakoum — Tue, 30 Sep 2014 11:59:36 GMT

no that is not available