topic How to get the first operation date? in QlikView

How to get the first operation date?

Mon, 03 Aug 2015 04:50:51 GMT

Dear Experts,

I have several dates in my pivot table and I would like to know the first working date for each Id.

In here, The start operation date for Id-113 is 02.06.2015 & Id-117 is 05.06.205. What function is appropriate to get the first operation date in this process?

Best Regards,

Kyaw Myo Tun

Re: How to get the first operation date?

PrashantSangle — Mon, 03 Aug 2015 04:53:50 GMT

Hi,

You can use FirstSortedValue() or Min()

Regards

Re: How to get the first operation date?

Mon, 03 Aug 2015 05:02:10 GMT

Dear Max dreamer,

I have some aggregation functions on that pivot table and Kindly ask to get an example for that on text pane because I am using personal edition.

Best Regards,

Kyaw Myo Tun

Re: How to get the first operation date?

PrashantSangle — Mon, 03 Aug 2015 05:11:25 GMT

Hi,

Do the following changes in script,

try like

TableTest:

Load

Your Existing Script

from tableNAme;

Left Join

Load ID,

Min(Date) as minDate

Resident of TableTest

group by ID;

Regards

Then use minDate in your chart.

Regards

Re: How to get the first operation date?

MarcoWedel — Mon, 03 Aug 2015 06:16:12 GMT

FirstSortedValue(Total<Id> Date)

hope this helps

regards

Marco

Re: How to get the first operation date?

jagan — Mon, 03 Aug 2015 07:03:35 GMT

Hi,

You can use this as expression

=Min(TOTAL <Id> Date)

Hope this helps you.

Regards,

Jagan.

Re: How to get the first operation date?

MarcoWedel — Mon, 03 Aug 2015 21:19:39 GMT

maybe also possible:

Date(Min(Total<Id> Date))

regards

Marco