topic Qlik sense set analyses with multi date fields in App Development

Qlik sense set analyses with multi date fields

RvS — Sat, 16 Nov 2024 17:20:49 GMT

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:-)

Re: Qlik sense set analyses with multi date fields

rubenmarin — Sat, 27 Mar 2021 08:17:42 GMT

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.

Re: Qlik sense set analyses with multi date fields

RvS — Mon, 29 Mar 2021 06:46:07 GMT

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.