Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try like:
Sum({<Date={'>=$(=YearStart(Max(Date)))<=$(=Date(Max(Date)))'}, [Success Date]={"=[Success Date]-[Approached Date]>1/24/60*30"}>}Data)
This is not working i tried
Without a sample qvw, I have to stop here.
QlikCommunity Tip: How to get answers to your post?
Preparing examples for Upload - Reduction and Data Scrambling