Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cmtassone
Partner
Partner

Impact Analysis Syntax

Hello, first post here, hoping you can help. I need to calculate impact of revenue for our fiscal year (9/30/2020) using a close date + 30 days from our sales funnel.

I calculated the daily revenue and then multiplied to remaining days in fiscal year from expected close date. Issue is that Expected Close Date is a field and is not part of the dataset and IsFTD filter below, therefore pulling other items in from our sales funnel. How can I fix this so it properly calculates impact?

=(Sum({$<DataSet={"Combined"}, IsFtd={'1'}>} AnnualValue)/365) * (274-DayNumberOfYear(ExpectedCloseDate)+30)

Thanks in advance.

0 Replies