topic Re: Time in QlikView

Time

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Please find the screen shots . let me try to explain it in a simple wasy

I have success date , appraoched date

My requirement are

it should show count of custome id less than 50 mints for the below formula

Success date - approached date lessa than 50 mints .

(i want to show count of those cusotmer id who appraoched before 30 mints after subracting appraoched date from success date ).

I hope i am clear now

Thanks in advance

Re: Time

tresB — Tue, 20 Sep 2016 05:45:42 GMT

Try to share a sample data set in qvw and explain your expected output against that. That would help us help you.

Re: Time

smilingjohn — Tue, 20 Sep 2016 05:55:29 GMT

hi tresesco

Just need to know the formula to calculate the ytd which are less than 30 mints

if u can give me a basic formula will be helpfull

Re: Time

ramasaisaksoft — Tue, 20 Sep 2016 05:58:40 GMT

Hi John,

SET TimestampFormat='DD/MMM/YYYY hh:mm:ss[.fff]';

TIMESTAMP([ Approval Due Date],'hh:mm:ss[.fff]') as [Approval Due Date_Time]

after that you can write the condition as per your wish

Re: Time

tresB — Tue, 20 Sep 2016 06:20:40 GMT

Something like:

Sum({<Date={'>=$(=YearStart(Max(Date)))<=$(=Date(Max(Date)))'}, MinuteField={'>30'}>}Data)

Note: Your minute field is assumed to be created in the script using minute().

Re: Time

smilingjohn — Tue, 20 Sep 2016 06:27:12 GMT

Hi Rama,

I hae the date fomate in the same way you suggested

date= 25-03-2016 19:22: 27

i have cutomer field

CutomerID= cidt=aa1 .... and so on

now i want to show the count of customer less than 30 mints ?

how do i take 30 mint from above date

Re: Time

smilingjohn — Tue, 20 Sep 2016 06:33:09 GMT

HI tresesco

I have date field like this

date= 25-03-2016 19:22: 27

and there is one more field like dateTime = 00:02:21

shall i consider date time as minute field to define less than 30 ?

Re: Time

tresB — Tue, 20 Sep 2016 06:45:58 GMT

John Roy wrote:

hi tresesco

Just need to know the formula to calculate the ytd which are less than 30 mints

if u can give me a basic formula will be helpfull

So the basic formula did not much help. . That is why a sample was asked for to minimize the follow up questions. Check if you can share one.

Re: Time

smilingjohn — Tue, 20 Sep 2016 07:09:06 GMT

HI tresesco

Please find the screen shots . let me try to explain it in a simple wasy

I have success date , appraoched date

My requirement are

it should show count of custome id less than 30 mints for the below formula

Success date - approached date lessa than 30 mints .

(i want to show count of those cusotmer id who appraoched before 30 mints after subracting appraoched date from success date ).

I hope i am clear now

Thanks in advance

Re: Time

Digvijay_Singh — Tue, 20 Sep 2016 07:24:15 GMT

This formats the time part into minutes -

=interval(round(frac(date('25-03-2016 19:22:27')),1/(24*60)),'mm')

Re: Time

smilingjohn — Tue, 20 Sep 2016 07:26:51 GMT

HI Digvijay ,

below is the date format what i have in my app , as shown in the snap shot .

i need to show

(i want to show count of those cusotmer id who appraoched before 30 mints after subracting appraoched date from success date ).

Thanks

Re: Time

tresB — Tue, 20 Sep 2016 07:28:47 GMT

Try like:

Sum({<Date={'>=$(=YearStart(Max(Date)))<=$(=Date(Max(Date)))'}, [Success Date]={"=[Success Date]-[Approached Date]>1/24/60*30"}>}Data)

Re: Time

smilingjohn — Tue, 20 Sep 2016 08:49:47 GMT

This is not working i tried

Re: Time

tresB — Tue, 20 Sep 2016 08:54:32 GMT

Without a sample qvw, I have to stop here.

QlikCommunity Tip: How to get answers to your post?

Uploading a Sample

Preparing examples for Upload - Reduction and Data Scrambling