Qlik sense set analyses with multi date fields

[RvS]

Hai to all, i'm Ronald from the nederlands

Date and set analyses - its a disaster - so is the English language while being a dyslect:-)

=Sum({$<Jaar={$(vSelYear)},Logic4_KlantDatFlag={1},[Datum] = {">=Min(Date#([L4_BeginDate],'DD-MM-YYYY'))<=Max([L4_EndDate])"}>}[#Omzet])

Datum is a field in a Fact table and a dim master calendar (Date)
L4_BeginDate and L4_EndDate are fields in Dim table with customer numbers and begin and end dates 

Sum only when Datum >= Logic4_BeginDate

It does not work:-(

Hope someone knows:-)

[rubenmarin1]

Hi, syntax might be:

=Sum({$<Jaar={$(vSelYear)},Logic4_KlantDatFlag={1},[Datum] = {">=$(=Min(Date#([L4_BeginDate],'DD-MM-YYYY')))<=$(=Max([L4_EndDate]))"}>}[#Omzet])

I'm not sure what are you trying but note that set analysis is calculated for the whole dataset, not row by row, so dates filtered will be the same for all customers, not one by one.

[RvS · Accepted solution]

Thanx Ruben, unfortunately it does not work.. and yes i hoped it would work for the whole dataset.
i better put a flag in the Fact table for counting or not.