topic Re: How to Get Date and Time from Max Transaction in QlikView

How to Get Date and Time from Max Transaction

d4rlie891 — Thu, 11 Aug 2016 06:30:06 GMT

Hi,

Anybody can help me, how to get Date and Time from Max Transaction?

Thanks

Darlie

Gysbert_Wassenaar — Thu, 11 Aug 2016 08:44:32 GMT

FirstSortedValue(DAY, -TRX)

FirstSortedValue(TIME, -TRX)

d4rlie891 — Thu, 11 Aug 2016 09:53:39 GMT

Hi Thanks for your Help, Could you please tell me how get the Time from Max Transaction that happen in (time 10:00 - 10:55)

Thanks n Regards

Gysbert_Wassenaar — Thu, 11 Aug 2016 10:26:29 GMT

Maybe like this: FirstSortedValue({<TIME={'>10:00<10:55'}>}TIME, -TRX)

d4rlie891 — Thu, 11 Aug 2016 11:02:32 GMT

Thanks So Much.

May I ask you one more thing, what is the correct Syntax if I want to add AVG on TRX?

the result is null : FirstSortedValue({<TIME={'>10:00<10:55'}>}TIME, -(Avg(TRX))

Thanks

sunny_talwar — Thu, 11 Aug 2016 14:27:36 GMT

Find the Avg(TRX) based on what dimension here?

d4rlie891 — Fri, 12 Aug 2016 01:05:46 GMT

Hi Sunny,

Sorry, here is the detail : I need to know the DAY of Max AVG (ESAP).

For Example, The Max Avg is on Day 9

Thanks

sunny_talwar — Fri, 12 Aug 2016 09:46:33 GMT

You want to know the day of max average? may be this:

FirstSortedValue(DAY, -Aggr(Avg(TRX), DAY))

d4rlie891 — Mon, 15 Aug 2016 02:18:03 GMT

It' Work, Thanks For your Help