I need to do a set analysis, but it's proving a bit tricky. I'm trying to return the Accounts.Name tagged as 'tier 1', which do not have an associated Activities.AccountID in the last 30 days.
My underlying table has 4 columns
In my example data I have 5 accounts and 2 of them are tagged as 'tier 1'. However, of the two 'tier 1' firms only Big Company llp has not had an actiivity within the last 30 days, so that is the result I would want displayed in a table, just the Accounts.Name.
Sample data is provided below
The data model I gave you was slightly incorrect. Which is my fault. I've have attached the correct one
There is not a blank row for each account on each date. There is only one blank row for a date, if there are no activities at all for that day.
How would the expression differ for this new data model?
srchilukoori, I am a bit of a Qlikview beginner, so how would I insert your load script into mine? I have a separate tab to load each object, so how would I amend my Accounts load script to fit yours in?
LOAD Id AS Activity.AccountId,
Id AS AccountIdforTag,
SQL SELECT *
Please provide the script equivalent for the below in your app, so I can modify mine accordingly.
(ooxml, embedded labels, table is Sheet1);
It's a load directly from salesforce.com database, so there is no load script as you describe.
All i have is
CUSTOM CONNECT TO "Provider=SalesForceDLL.dll;F26;XUserId=ISdGAWRM..............................
In that case, just do a resident load of the following fields/ logic after the data is loaded from SFDC.
LOAD Distinct Accounts.Name,
Today() - Max(Activity.CalendarDate) As [Days since Last Activity]
Where AccountTags.Name = 'Tier 1' and Len(Trim(Activities.AccountId))<>0
Group by Accounts.Name;