topic Recent Record in the table in QlikView

Recent Record in the table

Anonymous — Tue, 24 Aug 2010 01:08:28 GMT

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

Recent Record in the table

Tue, 24 Aug 2010 09:19:52 GMT

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)

Recent Record in the table

Anonymous — Tue, 24 Aug 2010 19:36:04 GMT

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

Recent Record in the table

Anonymous — Wed, 25 Aug 2010 17:31:45 GMT

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.

Recent Record in the table

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 17:38:56 GMT

Hello,

Try something like

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

Hope that helps.

Recent Record in the table

Anonymous — Wed, 25 Aug 2010 17:48:44 GMT

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_time	number_of_users
2010-08-25 09:23:37	5
2010-08-25 09:08:46	6
2010-08-25 08:53:46	10
2010-08-25 08:38:39	20

Recent Record in the table

montubhardwaj — Wed, 25 Aug 2010 18:29:11 GMT

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

hope that was helpful.

Regards,

Sharma

Recent Record in the table

Clever_Anjos — Wed, 25 Aug 2010 18:57:15 GMT

Try this

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

Recent Record in the table

Anonymous — Wed, 25 Aug 2010 19:01:07 GMT

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

Recent Record in the table

Clever_Anjos — Wed, 25 Aug 2010 19:05:12 GMT

have you tried Max()?

Recent Record in the table

Clever_Anjos — Wed, 25 Aug 2010 19:05:46 GMT

Max(end_time), I meant

Recent Record in the table

Anonymous — Wed, 25 Aug 2010 19:09:17 GMT

Thank you!