Logic Replication from Salesforce to Qlik

Mouni09 — Mon, 23 Jun 2025 17:54:13 GMT

Hello Guys,

I am working replication of one dashboard from salesforce to Qlik

salesforce logic:
7-day fee (#):

IF(
and(
not(isblank(Ld.En_Date_Time__c)),
(Ld.En_Date_Time__c - CREATED_DATE) <= 7
),
1,
0
)

Rowcount: Count(Ld ID)

Final formula : sum(CDF1:SUM)
/
sum(RowCount)
CDF1 is nothing but 7-day fee (#)

Essentially it is taking the 7-day Engage # / Total lds during that time period

I need to show created_date as dimesnion, that to only 16 weeks of date starting from week, 1st week -- 3/2/2025 - 3/8/2025 to 16th week -- 6/15/2025 - 6/21/2025
dimesnion should also show like above weekstart- weekend as one point etc

Qlik I tried:
Dimension:
=If(
WeekStart([Created_Date]) >= WeekStart(Today() - 7 * 16) and
WeekStart([Created_Date]) < WeekStart(Today()),
Date(WeekStart([Created_Date]), 'M/D/YYYY') & ' - ' & Date(WeekEnd([Created_Date]), 'M/D/YYYY')
)

Measure:

Num(
Sum(
If(
Not IsNull([Ld En Date])
and ([Le En Date] - [Created_Date]) <= 7,
1, 0
)
)
/
Count(distinct[Ld ID])
, '0.00%')

I'm not getting same result in qlik like in salesforce am I doing wrong anywhere?

Re: Logic Replication from Salesforce to Qlik

Kaushik2020 — Tue, 05 Aug 2025 10:26:13 GMT

are you able to see the same date range in Qlik expression editor for the mentioned expression ?

topic Re: Logic Replication from Salesforce to Qlik in App Development

Logic Replication from Salesforce to Qlik

Re: Logic Replication from Salesforce to Qlik