topic Re: Sorting Expression in QlikView

Sorting Expression

Mon, 12 Dec 2016 04:52:02 GMT

Hello All,

I am unable to sort the table below:

Name	Login	Logout
Sanchez	08:50:00	17:00:00
Laurent	09:02:00	18:00:00
Francis	08:05:00	17:01:00
Theo	08:55:00	18:05:00
Olivier	07:59:00	16:59:00

I tried using all the options in the sorting tab but nothing is working. I set the login first.

I need the login to sort in ascending order. Is there an expression which i can use.

Thanks,

Hasvine

Re: Sorting Expression

tamilarasu — Mon, 12 Dec 2016 05:10:48 GMT

Hi Hasvine,

Make sure to promote the Login field to top and try this as sort expression.

=Time#(Login,'hh:mm:ss')

Re: Sorting Expression

rido1421 — Mon, 12 Dec 2016 05:12:47 GMT

Hi Hasvine

Have you got "Login" 1st on your sort Priority?

See attachments...

Re: Sorting Expression

Anonymous — Mon, 12 Dec 2016 05:28:02 GMT

Hi,

if you are using straight table,

in sort tab

select our filed login and promote that filed in to top

then

sort by

numerical order-ascending

then you will get our output.

Re: Sorting Expression

Mon, 12 Dec 2016 05:48:25 GMT

Hello All,

Thanks for the reply.

It is straight table.

I tried all the tips provided but it does not work.

See below:

Thanks,

Hasvine

Re: Sorting Expression

Anonymous — Mon, 12 Dec 2016 06:03:13 GMT

Hi hasvine,

From this Your are used descending ,you have to use ascending to get what you want,

and

i think you have some additional filed like date in your table. sort by the date filed also ascending order.

Re: Sorting Expression

Mon, 12 Dec 2016 06:11:06 GMT

Hello All,

Nothing is actually working. I put the login first, in ascending and descending but the value does not change.

I have 2 dimensions, Date and Name

and I have 2 Expressions, Login and Logout.

I tried putting the date first and login second but no luck there either.

Any idea?

Thanks,

Hasvine

Re: Sorting Expression

tamilarasu — Mon, 12 Dec 2016 06:19:33 GMT

Hasvine,

Please attach your application.

Re: Sorting Expression

Mon, 12 Dec 2016 06:46:44 GMT

Hello All,

I found the issue.

Actually in the table i was using an expression to make 1 line white and 1 line grey as below:

=if(mod(rowno(TOTAL), 2) = 1, white(), rgb(212,212,212))

Once i removed the expression, it worked well.

Thanks everyone for your help.

Kind Regards,

Hasvine