Time

[smilingjohn]

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

[smilingjohn]

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

[tresesco]

Try like:

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

[smilingjohn]

This is not working i tried

[tresesco]

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