topic Regarding date in QlikView

Regarding date

nizamsha — Tue, 04 Jun 2013 06:14:21 GMT

Hi All

i have one problem in date

i hvae a field called documentdateglpca and postingdate glpca, both of the date is in the same table say glpca..i have loaded only one table so there is no link to other table what i want exactly is i want to check the minimum and maximum date of document dateglpca..we normally use to find in this manner

min(documentdate)

max(documentdate ) usually we will find the min and max of document date or we use date(max(documentdate)),date(min(documentdate))

i want to check this min and maxdate how to check in excel or in some other manner .because i knw the mindate is 1-2-2006 and maxdate is 1-3-2011

but for me its coming in this manner mindate is 1-2-2006 and max date is 1-3-2111

can any one tell me how to crosscheck the date what i am in qvd .and also listbox the date what its displaying

Re: Regarding date

sujeetsingh — Tue, 04 Jun 2013 06:23:07 GMT

Just post a sample

Re: Regarding date

nizamsha — Tue, 04 Jun 2013 06:44:06 GMT

i want to check the date what i am gettting in my listbox or table box weather is a wright date or not how to check that one

Re: Regarding date

Tue, 04 Jun 2013 06:52:52 GMT

ur question is nt clear.....

can u post the date format of the excel sheet u're using as the source of data ?

Re: Regarding date

saumyashah90 — Tue, 04 Jun 2013 06:55:39 GMT

See everything dependent on source file.

So just check the source whether in it there is some problem or not.

Just check the format while loading it in Qlikview

Put Date(Date_Field,'MM-DD-YYYY') while loading.

If this does not correct the error,it means there is some problem with your source file.

Re: Regarding date

saumyashah90 — Tue, 04 Jun 2013 06:55:57 GMT

See everything dependent on source file.

So just check the source whether in it there is some problem or not.

Just check the format while loading it in Qlikview

Put Date(Date_Field,'MM-DD-YYYY') while loading.

If this does not correct the error,it means there is some problem with your source file.

Re: Regarding date

saumyashah90 — Tue, 04 Jun 2013 07:09:47 GMT

In QlikView you can cross check by putting a text object and in General->Text -> =Max(Date_Field)

Re: Regarding date

nizamsha — Tue, 04 Jun 2013 07:16:49 GMT

THANKS sumya i have cross checked but its not working its showing only the date wht its displaying in the listbox ..wht i am asking is for eg i am hving one excel file and loading it ..in that table i have a date field we usually cross check using texbox

date(max(documentdate)),date(min(documentdate))

min(documentdate)

max(documentdate )

we will get some date for mini and maxi but is that the right one nu how to check ..thats my need

Re: Regarding date

saumyashah90 — Tue, 04 Jun 2013 07:26:20 GMT

Once you load.

press ctrl+t,you will get tables you have made and their linking. just right click on the table name in which dates are present and see the preview

If that date is present that mean their is nothing wrong with th qlikview.Their is surely problem in Source file from which you are making qvd.

For example:Some times it happens that in excel sheet we have dates till 2-6-11 and we get in display of qvw 2-6-1999 or 2-6-2111

Hence just check the source file.

Re: Regarding date

saumyashah90 — Tue, 04 Jun 2013 07:38:22 GMT

Also try keeping it detached i.e

=max({1}Date(Date_Field,'DD-MMM-YYYY'))

Re: Regarding date

sujeetsingh — Tue, 04 Jun 2013 08:27:43 GMT

It seems that we are not able to get you if possible give a sample .

Re: Regarding date

er_mohit — Tue, 04 Jun 2013 08:46:31 GMT

if you want to cross check date then try to use firstsortedvalue in text object

seems like

firstsortedvalue(Fieldvalue,-Date) // here fieldvalue those fieldname on the basis of max.Date it gives the value

and for min date try this

firstsortedvalue(Fieldvalue,Date) //make sure date format is same if different then try this in replace of Date

Date(date#(DateField,'DD/MM/YYYY'),'DD-MM-YYYY') THE FIRST FORMAT IS YOUR DEFAULT AND SECOND ONE IS WHICH YOU USE

hope it helps