Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting Expression

Hello All,

I am unable to sort the table below:

 

NameLoginLogout
Sanchez08:50:0017:00:00
Laurent09:02:0018:00:00
Francis08:05:0017:01:00
Theo08:55:0018:05:00
Olivier07: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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

8 Replies
tamilarasu
Champion
Champion

Hi Hasvine,

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

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

rido1421
Creator III
Creator III

Hi Hasvine

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

See attachments...

Anonymous
Not applicable
Author

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.

Not applicable
Author

Hello All,

Thanks for the reply.

It is straight table.

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

See below:

Capture-sort.PNG

Capture-sort2.PNG

Thanks,

Hasvine

Anonymous
Not applicable
Author

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.

Not applicable
Author

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

tamilarasu
Champion
Champion

Hasvine,

Please attach your application.

Not applicable
Author

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