Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

which expression is faster

Hello
I got the following expression:

Sum({
<PROJECT_TYPE_CATEGORY={[Support],[Delivery],[License / Presale]},YEAR-={$(=vL.CurrentFiscalYear)},SCENARIO_TYPE={[ACTUAL]}>

}Field1 + Field2)
+

sum(
{<PROJECT_TYPE_CATEGORY={[Support],[Delivery],[License / Presale]},YEAR={$(=vL.CurrentFiscalYear)},SCENARIO_TYPE={[$(vL.CurrentFiscalYearLatestScenarioType)]}>
}Field1 + Field2)

is the below approach faster than the one above? 


Sum({
              <PROJECT_TYPE_CATEGORY={[Support],[Delivery],[License / Presale]},YEAR-=                    {$(=vL.CurrentFiscalYear)},SCENARIO_TYPE={[ACTUAL]}
              >
+
            <PROJECT_TYPE_CATEGORY={[Support],[Delivery],[License / Presale]},YEAR={$(=vL.CurrentFiscalYear)},SCENARIO_TYPE={[$(vL.CurrentFiscalYearLatestScenarioType)]}
              >
}Field1 + Field2)

@swuehl 
@sunny_talwar     if you can help here, then kindly advise

I can walk on water when it freezes
Labels (2)
0 Replies