Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Expression

Hi there,

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

My formula:

 

if

([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*

5 Replies
Not applicable
Author

Try

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

jerem1234
Specialist II
Specialist II

try:

if

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

Not applicable
Author

try

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

techvarun
Specialist II
Specialist II

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

Please try this

Not applicable
Author

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]))