topic Re: How to put function in set analysis in QlikView

How to put function in set analysis

Wed, 04 Jul 2012 04:02:29 GMT

i want to pull out the MemberID while AuditInsertDate is max one , i used many function but it is not working well

max

({$<AuditInsertDate={'<$(= max(AuditInsertDate)'}>} Member_id

)

anyone know hot to do it

perumal_41 — Wed, 04 Jul 2012 04:36:21 GMT

Hi,

Try this Expression

max

({$<AuditInsertDate={'<$(= max(AuditInsertDate))'}>} Member_id

)

Wed, 04 Jul 2012 04:42:08 GMT

Hi there,

I used the following:

Max({<AuditInsertDate={$(=Max(AuditInsertDate))}>} Member_id)

Leo

Wed, 04 Jul 2012 05:48:02 GMT

not working!

datatable like this

perumal_41 — Wed, 04 Jul 2012 05:58:53 GMT

Hi ,

If possible upload sample Application

Regards

Perumal A

Wed, 04 Jul 2012 06:44:43 GMT

try this

Max({<AuditInsertDate={$(=Max(timestamp#(AuditInsertDate,'YYYY-MM-DD hh_mm'))}>} Member_id)

Thanks

priyanka

Wed, 04 Jul 2012 07:04:10 GMT

Hi max,

Just curious, can you do that during loading?

Regards,

Xue Bin