jrba0001

[jrba0001]

Good Morning. I'm new to QlikView and have many doubts, please can someone explain to me why this does not work?

 = Sum ({<$ (= Date (TD_ID_FEC_PLA.FEC_FECHA, "DD / MM / YYYY")) = { '> 10/01/2018'}>} CALC_UNIDAD_CEX_ASISTENCIA)

 TD_ID_FEC_PLA.FEC_FECHA is a field where DATE AND ARE CALC_UNIDAD_CEX_ASISTENCIA 1 to simplify the aggregation functions

[Gysbert_Wassenaar]

 = Sum ({<$ (= Date (TD_ID_FEC_PLA.FEC_FECHA, "DD / MM / YYYY")) = { '> 10/01/2018'}>} CALC_UNIDAD_CEX_ASISTENCIA)

The part in bold returns a value, but that value is very likely not the name of a field. You must use a field name on the left side of a set modifier. The part in red is a literal string. You most likely won't have values in your field that are the exact string '> 10/01/2018'.  In older versions of Qlikview that  kind of string might be accepted as a search string, but then it would look for values larger than 10 divided by 1 divided by 2018.

So you need to use a real field on the left side and a proper search string on the right side. Something like [TD_ID_FEC_PLA.FEC_FECHA] = {"> '10/01/2018' "}.

Possible the above doesn't work either and you need to turn the date string into a date value first: [TD_ID_FEC_PLA.FEC_FECHA] = {"> $(=Date#('10/01/2018','MM/DD/YYYY') "}