topic [ASK] unable to sort by formula-expression in QlikView

[ASK] unable to sort by formula-expression

Wed, 11 Aug 2010 04:53:29 GMT

hello..

i've a problem about sorting the data

why i can't sort by formula expression?

if i sort by the dimension, i able

but if i do it by the expression, i unable

is there any solution?

i've attached the qvw file also

many thx..

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8688.airinti_2D00_sample.rar:550:0]

[ASK] unable to sort by formula-expression

Wed, 11 Aug 2010 05:20:24 GMT

Hi,

The document is asking for User ID. Please provide the credentials

-Haneesh

[ASK] unable to sort by formula-expression

Wed, 11 Aug 2010 05:21:04 GMT

i'm sorry

the user and pass : admin

[ASK] unable to sort by formula-expression

tresB — Wed, 11 Aug 2010 06:16:55 GMT

Hi ,

Why it is not working that way might be answered in a little more R&D. But the quick solution is here. Select the dimension in the sort tab and write the same expression(you want to sort by ) in the sort by- expression window. For ease please find the attachment(snapshot).

Hope this would help!

Regards,

tresesco

[ASK] unable to sort by formula-expression

Thu, 12 Aug 2010 07:46:53 GMT

hello tresesco

i've tried ur solution, but it doesn't work neither

[ASK] unable to sort by formula-expression

tresB — Thu, 12 Aug 2010 08:23:08 GMT

Hi Kribo,

It seems that you are getting some thing misodering in the sort tab. The dimention should be at the top of priority and then by selecting it you have to write the expression to sort it by. You can even ignore the sort option for rest of the columns(in sample application some are marked....which are redundant.)

Please find the attachment.

Regards,

tresesco

[ASK] unable to sort by formula-expression

Thu, 12 Aug 2010 12:32:38 GMT

@tresesco

thx bro for helping

i think it is because the formula is too complicated

i'll think to make a view table to handle it

thx