topic Re: Date Expression in QlikView

Date Expression

Fri, 09 Mar 2012 08:29:54 GMT

Hi Can anyone please help, I am stuck.

I have data in my ecxel file of things that happen today, but I only want a button to return data of things that happen starting from 06:00 AM until now. using this date format: 2012/03/09 8:15:19 AM

Thanks in advance

Re: Date Expression

jvitantonio — Fri, 09 Mar 2012 08:48:21 GMT

Here you go

Date Expression

CELAMBARASAN — Fri, 09 Mar 2012 08:49:58 GMT

Hi,

Try with this expression.

Sum(DateField={">=$(=TimeStamp(Floor(Today())+Time#('06:00','hh:mm')))<=$(=Now())"} Sales)

Hope it helps

Celambarasan

Date Expression

perumal_41 — Fri, 09 Mar 2012 08:50:45 GMT

Hi,

use this Scirpt for helpful for u

Load * From

Excelfile where Datefiled >='2012/03/09 6:00:00 AM'

Regards

Perumal A

Re: Date Expression

Fri, 09 Mar 2012 09:29:06 GMT

Thanks guys for your replies, I have not been able to find the solution yet, please find the test model I created, in the mean time the button can return all the tings that happen today, but im not able to figure out how to get the things that happen from 6:00 until now.

Regards

Edzi

Re: Date Expression

perumal_41 — Fri, 09 Mar 2012 10:06:11 GMT

Please Chech This Application is correct or Not

Regards

Perumal

Re: Date Expression

Fri, 09 Mar 2012 10:23:10 GMT

Hi Perumal

It works when you right the expression on the table, but I cant get it working using a button.

Regards

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful

Re: Date Expression

perumal_41 — Fri, 09 Mar 2012 10:48:40 GMT

I attached Application and This Application U Reload . u Get Result

Re: Date Expression

Fri, 09 Mar 2012 11:10:38 GMT

Thanks man, I got it now.

If I may ask again using the same code, how can I get the data that happen a week back from today and a month back from today?

Regards

Edzi

Re: Date Expression

Fri, 09 Mar 2012 11:43:47 GMT

Hi ,

I was trying using the button , but I didn't get the solution. Instead I found the alternative solution for you using the straight table which gives the today's date from 6:00 AM to till now. File is attached.

Hope it will help you.

Do let me know if any concern.

Reards,

Kush

Re: Date Expression

perumal_41 — Fri, 09 Mar 2012 12:55:10 GMT

I attached Application and This Application U Reload . u Get Result

Re: Date Expression

Mon, 12 Mar 2012 06:37:02 GMT

Hi, Perumal

Thanks for you help, I am now able to select only the data from 6:00 AM until now, the other question I ask is how, If possible can I select the data that happen a week back starting from now, and a month back starting from now.

Thanks

Edzi

Re: Date Expression

Mon, 12 Mar 2012 06:40:02 GMT

Hi Khush

The one where you use a straight table works fine, the challenging one is when using a button, but you can check the example that was given by Perumal in his previous reply to see how he did it.

Regards

Edzi

Re: Date Expression

perumal_41 — Mon, 12 Mar 2012 10:07:38 GMT

Hi Edzi,

How u Want Result . Little Bit Breifly Explain.

How do Selection through Button or List Box Previous Month or Previous Week

Regards

Perumal A

Re: Date Expression

Mon, 12 Mar 2012 10:20:08 GMT

Hi Perumal

Please see the attached file,

- The Daily Button Is the one we were working with, where it has to return today’s data from 6:00 AM.

- Weekly Button has to return all the data that happened starting from now to 7 days back.

- And monthly button has to return data starting from now to 31 days back.

The data has to be returned on the same table when a button is clicked.

Regards

Edzi

Re: Date Expression

jvitantonio — Mon, 12 Mar 2012 11:38:33 GMT

Hi, sorry for the delay. Here's the solution. I'm not very good at working with dates, so you may find a "cleaner" solution, but for now, it works.

Date Expression

Mon, 12 Mar 2012 12:19:26 GMT

Thanks for the reply, the file you attached works fine, but can you do the same without using the Test_Date values but only using the Test_Date1 values some how when I use the values from Test_Date1 only it doesnt work, I guess due to the formating of dates.

Regards

Edzi

Date Expression

Mon, 12 Mar 2012 12:33:33 GMT

The other thing that I just noticed now, if I change the fields and only use the values from the Test_Date1, it does not return any data from today.

Regards

Edzi

Date Expression

jvitantonio — Mon, 12 Mar 2012 13:10:49 GMT

Why can't you use the fild? Can you give me the excel file so I Can play with the formats? Or you can playwith them and invest your own time 😉

Re: Date Expression

Mon, 12 Mar 2012 13:28:10 GMT

The Test_Date1 field is the one with the correct date format I have to use, I have been trying to play with the formats myself and they have started to be a bit confusing ☺

Kind regards

Edzi