Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis in Straight Table {'<=$(=...)'}

Hi ,

there is an error in this set analysis,

can you tell me what is wrong?

I can not use a variable for the central expression for other reasons...

Thank you all.

M.

=sum({$<Day=

{'<=

$(=if($(vCurrentWorkDay)<15,$(vCurrentWorkDay),

(max({$<Year={$(vPrevYear)}, Month={$(vCurrentMonth)}>}Day)-

(max({$<Year={$(vCurrentYear)}, Month={$(vCurrentMonth)}>}Day)-

Only({$<Cdr_Day={$(=if(max(Cdr_Day) <= vCurrentDay, max(Cdr_Day), vCurrentDay-1 ))}>} Day))))

)'}

, Month={$(=Only(Month))}>} Actual)

0 Replies