Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
= 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') "}