topic Re: set analysis problem with funtion in QlikView

set analysis problem with funtion

souadouert — Fri, 23 Feb 2018 08:30:29 GMT

=SUM({< PROJET_AVENIR_DATE_PRODUCTION={ "$(DATE_EXTRACTION) >= DATE(date(_DATE_OUVERTURE),'YYYYMMDD')"}>}MONTANT_PRODUCTION)

Ihave probleme with this expression

when i tested $(DATE_EXTRACTION) >= DATE(date(_DATE_OUVERTURE),'YYYYMMDD') in selection object , it works but when i integrted this expression with this set analysis expression didnt work

Re: set analysis problem with funtion

alexandros17 — Fri, 23 Feb 2018 08:36:12 GMT

The expression cannot work in set analysis because "_DATE_OUVERTURE" is a field, not a variable.

The right side of a set analysis expression must have fixed values as variables or aggregated values such Max(_DATE_OUVERTURE) for instance.

Re: set analysis problem with funtion

hic — Fri, 23 Feb 2018 09:45:47 GMT

You could probably use

=SUM({<_DATE_OUVERTURE={"<$(DATE_EXTRACTION)"}>} MONTANT_PRODUCTION)

instead. Just make sure that _DATE_OUVERTURE is interpreted correctly in the script, and that it has the same format as the variable DATE_EXTRACTION.

HIC

Re: set analysis problem with funtion

sunny_talwar — Fri, 23 Feb 2018 12:34:03 GMT

May be you need an equal sign for the search string?

=Sum({<PROJET_AVENIR_DATE_PRODUCTION = { "=$(DATE_EXTRACTION) >= _DATE_OUVERTURE"}>} MONTANT_PRODUCTION)