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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Calculation - converting set analysis formula

Hi, I would like to do the following calculationg during load. However, I don't think we can do set analysis during load. The calculation is summing up REV (revenue) based on start and expiry date of the contract substracted by the REP (repairs) based on start and expiry date.

Thanks a bunch!


sum( {$<TranDate={'>=$(=(min(GM_START)))<=$(=(max(GM_EXP)))'}>} REV )
- sum( {$<TranDate={'>=$(=(min(GM_START)))<=$(=(max(GM_EXP)))'}>} REP ) as profit


your friendly neighborhood noob,

Chhai.

0 Replies