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: 
Anonymous
Not applicable

Recent Record in the table

Hi

I need to display the values in a chart where the datetime filed in the table is the most recent :

How do i write that in the expression of the chart,

For eg:

I have 2 columns in a table - end_time, no of users

I need to get number of users recently used the system where the end_time is the most recent time stamp.

Thanks

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Max(end_time), I meant

View solution in original post

11 Replies
Not applicable
Author

For your example, type the following code in a text box:

right(concat([no of users],',' ,end_time), index(concat([no of users],',' ,end_time),',')-1)

Anonymous
Not applicable
Author

Thank you for the reply..This code is displaying a comma in front of the value ..how can i avaoid this..

Anonymous
Not applicable
Author

could anybody please help me, how do i write this expression in chart?

the above expression when written in a text box gives "," in front of the value.

I basically need a Gauge chart with LED setting ti display the number of users where end_time is max time.

Miguel_Angel_Baeyens

Hello,

Try something like

Count({< end_time = {"$(=Max(end_time))"} >} UserID)


Hope that helps.

Anonymous
Not applicable
Author

I think i am not clear with my qyestion , i already have calculated data in my table , only thing i need is to display the no of users value in a chart with the max(end_time).

Basically users of the report what to see the number users at current time stamp , or recent time stamp in the table.

According to the below sample data ,

I want 2010-08-25 09:23:37 and 5 to be displayed in the chart.

Sample Data:

End_timenumber_of_users
2010-08-25 09:23:375
2010-08-25 09:08:466
2010-08-25 08:53:4610
2010-08-25 08:38:3920


montubhardwaj
Specialist
Specialist

try something like this: =count(If((End_Time)=Max(End_Time),No of users))

hope that was helpful.

Regards,

Sharma

Clever_Anjos
Employee
Employee

Try this

Only({< end_time = {"$(=Max(end_time))"} >} UserID)

Anonymous
Not applicable
Author

Thank you this workd..could you please let me know how do i display that time stamp also in the chart

i want to display something like below

2010-08-25 09:23:37

5

Clever_Anjos
Employee
Employee

have you tried Max()?