topic Dates substruction issue in QlikView

Dates substruction issue

Mon, 07 Nov 2016 18:09:02 GMT

Please guys I need your help.

If I choose the day D, I need an expression that allows me to calculation the production between D 05:59:57 and D+1 05:59:57

Example:

If I choose the date 06/06/2016, I should have the production between the day 06/06/2016 05:59:57 and 07/06/2016 05:59:57.

Thank you.

Re: Dates substruction issue

kaushiknsolanki — Mon, 07 Nov 2016 18:39:20 GMT

Hi,

You can use the set analysis to extend your selection.

Sum({<Date = {">=$(=Max(Date))<=$(=Max(Date)+1)"}>}ProductionQty)

Regards,

Kaushik Solanki

Re: Dates substruction issue

Mon, 07 Nov 2016 18:46:39 GMT

My production is excatly between today's quantity at 05:59:57 and tomorrow's quantity at 05:59:57.

Re: Dates substruction issue

kaushiknsolanki — Mon, 07 Nov 2016 18:52:29 GMT

Try this,

Sum({<Date = {">=$(=Timestamp(Floor(Max(Date))+num(Maketime(05:59:57))))<=$(=Timestamp(Floor(Max(Date))+1+num(Maketime(05:59:57)))))"}>}ProductionQty)

Regards,

Kaushik Solanki

Re: Dates substruction issue

Mon, 07 Nov 2016 18:59:16 GMT

the problem is the timestamp that i have is complicated,this is an example : 2016-11-01 00:01:49.1810000 +00:00

I want to extract days, months and years but it's complicated , please help

Re: Dates substruction issue

Mon, 07 Nov 2016 19:05:13 GMT

the problem is the timestamp that i have is complicated,this is an example : 2016-11-01 00:01:49.1810000 +00:00

I want to extract days, months and years but it's complicated , please help

Re: Dates substruction issue

kaushiknsolanki — Mon, 07 Nov 2016 19:06:41 GMT

Hi Lou,

Its better if you can hare some sample data with us.

Regards,

Kaushik Solanki

Re: Dates substruction issue

Mon, 07 Nov 2016 19:19:06 GMT

Hi kaushik, can you please show me how to share data here

Thank you

Re: Dates substruction issue

kaushiknsolanki — Mon, 07 Nov 2016 19:25:18 GMT

Have a look at the link.

Uploading a Sample

Regards,

Kaushik Solanki

Re: Dates substruction issue

Mon, 07 Nov 2016 20:12:47 GMT

Kaushik I tried to send it to you, but I couldn't the file is heavy or something

Here is a picture of Timestamp I have in my database.

thank you soo much

Re: Dates substruction issue

Mon, 07 Nov 2016 20:30:18 GMT

Kaushik I tried to send it to you, but I couldn't the file is heavy or something

Here is a picture of Timestamp I have in my database.

thank you soo much

Re: Dates substruction issue

Mon, 07 Nov 2016 21:03:56 GMT

Kaushik, Is there any other way where I can send you the sample data please ????