Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III
‎2018-08-21 09:45 AM

How to build a report where a deal has not been worked for at least 5 days .?

Hi All ,

How can I create a report which will have the deals which will show the member_id has not worked on the deal for at least 5 days.

My DB looks like below . the deal table looks like below.

DealDetails.PNG

Thanks

369 Views
0 Likes
1 Reply
neelamsaroha157
Specialist II
Specialist II
‎2018-08-21 09:58 AM

There are multiple ways of doing this, on of which is - get the max of the Update date by the member ID (calculating this in the script would be easier) then compare the maxMemberDate with the MaxSelectedDate-5 in the expression.

Variable - vMinDate = max(CalendarDate)-5

Count({<maxMemberDate ={"<=$(vMinDate)"}MemberID)

If the MaxSelectedDate is always today, then this can also be achieved at script level. Just compare the maxMemberDate  with Today()-5 and flag the records. Use the flag in the front end expression.


I hope this makes sense.

333 Views