topic Re: Reading the minimum value of a date. in QlikView

Reading the minimum value of a date.

Thu, 13 Jun 2013 06:52:13 GMT

Hi,

I have issues in using Min function to read a lowest date.

For a given quarter and fiscal year, I have all the dates for that quarter and need to find the start and end date of that quarter. My list box is displaying all the dates of the quarter and when I tried to use Min function, it doesn't display a record.

Following is my expression.

=if(GetFieldSelections(Years)=FISCAL_YEAR

and GetFieldSelections(Quarters)=FISCAL_QUARTER_NAME,Min(FISCAL_DATE))

If I remove Min(FISCAL_DATE) and use Fiscal date, it gives me all the dates of the quarter as below.

Any help is appreciated.

Thanks

Ramakanth

Re: Reading the minimum value of a date.

sushil353 — Thu, 13 Jun 2013 06:55:55 GMT

Try this

=if(GetFieldSelections(Years)='FISCAL_YEAR'

and GetFieldSelections(Quarters)='FISCAL_QUARTER_NAME',Date(Min(FISCAL_DATE),'MM/DD/YYYY'))

HTH

Sushil

Re: Reading the minimum value of a date.

Thu, 13 Jun 2013 07:05:48 GMT

Hi Sushil,

I tried this but not working, its still the same.

Date(FISCAL_DATE,'MM/DD/YYYY') is changing the format in MM/DD/YYYY but Date(Min(FISCAL_DATE),'MM/DD/YYYY') is giving an empty result.

Thanks

Re: Reading the minimum value of a date.

sushil353 — Thu, 13 Jun 2013 07:07:50 GMT

Try this:

Date(Min({1}FISCAL_DATE),'MM/DD/YYYY')

if still it is not working then post the sample app.

HTH

Sushil

Re: Reading the minimum value of a date.

sivarajs — Thu, 13 Jun 2013 07:23:20 GMT

min(date(date#(Date field,'Your date format'),'Format you want to convert'))

Re: Reading the minimum value of a date.

Thu, 13 Jun 2013 19:10:27 GMT

Hi Sushil,

I attached my app in my first post of this discussion. I am reading the data from Oracle, so you may not see the data..

Thanks