Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Time

HI

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

13 Replies
Highlighted
MVP
MVP

Re: Time

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

Highlighted
Creator III
Creator III

Re: Time

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

Highlighted
Specialist III
Specialist III

Re: Time

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

Highlighted
MVP
MVP

Re: Time

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().

Highlighted
Creator III
Creator III

Re: Time

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

Highlighted
Creator III
Creator III

Re: Time

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 ?

Highlighted
MVP
MVP

Re: Time

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.

Highlighted
Creator III
Creator III

Re: Time

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

Highlighted
Master III
Master III

Re: Time

This formats the time part into minutes -

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