topic Error in Expression in QlikView

Error in Expression

Fri, 19 Jul 2013 12:37:02 GMT

Hi there,

I want to show all contracts (agreements) that were Terminated in the month of June.

My formula:

([Date Sold]>='01/06/2013' or <='30/06/2013',count(DISTINCT [Agreement Number]))

It shows an Error in Expression message at the top of the expression box.

The problem is at the smaller or equal to 30/06/2013, because it underlines that symbols in red.

Can anyone help me with an alternative way of expressing my formula.

Thanks

*R*

Fri, 19 Jul 2013 12:39:23 GMT

Try

if([Date Sold]>='01/06/2013' or [Date Sold] <='30/06/2013',count(DISTINCT [Agreement Number]))

jerem1234 — Fri, 19 Jul 2013 12:40:10 GMT

try:

([Date Sold]>='01/06/2013' or [Date Sold]<='30/06/2013',count(DISTINCT [Agreement Number]))

Fri, 19 Jul 2013 12:45:18 GMT

try

([Date Sold]>='01/06/2013' AND [Date Sold]<='30/06/2013',count(DISTINCT [Agreement Number]))

techvarun — Fri, 19 Jul 2013 12:47:14 GMT

if ([Date Sold] >='01/06/2013' or [Date Sold] <='30/06/2013',count(DISTINCT [Agreement Number]))

Please try this

Fri, 19 Jul 2013 12:58:23 GMT

firstly in script write your date field according to this format--

date(date#([Date Sold],'DD/MM/YYYY'),'DD/MM/YYYY') AS [Date Sold]

THE TRY THIS

count(distinct if([Date Sold]>='01/06/2013' and [Date Sold] <='30/06/2013', [Agreement Number]))