topic Re: Date selection and Count expression not evaluating properly in QlikView

Date selection and Count expression not evaluating properly

Fri, 07 Nov 2014 11:54:11 GMT

Hello

Expression in chart: Count({<Doc_Date = {'>=$(vStartDate)<=$(vEndDate)'}>} {< ID = {">=$(vMaxID)"}>} EQUNR_S)

Selected Start Date 01.04.2014 and End Date 31.04.2014 but it's not evaluating properly also records are not filtered properly.

Count is coming wrong.

Act_Typ	EQUNR_S	ID	Doc_Date	Count
E	17603	3827	01.02.2011	1
T	17603	29198	15.04.2013	1
F	17603	29194	15.04.2013	1
D	17603	29196	15.04.2013	1

Ashif

Re: Date selection and Count expression not evaluating properly

alexandros17 — Fri, 07 Nov 2014 11:58:39 GMT

Sysntax is not correct ...

try this

Count({<Doc_Date = {'>=$(vStartDate)<=$(vEndDate)'}>}, ID = {'>=$(vMaxID)'}>} EQUNR_S)

Re: Date selection and Count expression not evaluating properly

Fri, 07 Nov 2014 12:06:13 GMT

I think synstax is right. Expression not evaluating.

Re: Date selection and Count expression not evaluating properly

kuba_michalik — Fri, 07 Nov 2014 12:43:56 GMT

Proper syntax is

Count({<Doc_Date = {">=$(vStartDate)<=$(vEndDate)"}, ID = {">=$(vMaxID)"}>} EQUNR_S)

Searches in set analysis go in double quotes. They might work with single quotes but it's a bug (single quotes should only be used for string literals) and taking advantage of it is not advisable.

If that doesn't work, then the likely reason is what the vStartDate, vEndDate and vMaxID variables are actually expanding to.

Are the numbers you posted a sample of the data, or how the table with this expression looks?