jrba0001

jrba0001 — Sat, 16 Nov 2024 21:45:21 GMT

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

Re: jrba0001

Gysbert_Wassenaar — Sat, 08 Dec 2018 11:17:39 GMT

 = 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') "}

topic jrba0001 in QlikView

jrba0001

Re: jrba0001