Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
SaraAbdulah
Contributor II
Contributor II

tow conditions

i need to calculate how many letters are not read more than five days with tow conditions:

status field (ISREAD= 0)

and the difference between received day and system date in days is more than 5 ([D_DIFF])> 5)

i tried this expression but i need some help to correct it

if((ISREAD= 0) and ([D_DIFF])> 5,count(DISPLAYNUMBER))

 

Labels (2)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this 

COUNT({<ISREAD={0}, [D_DIFF]={'>5'}>} DISPLAYNUMBER)

 

View solution in original post

1 Reply
Chanty4u
MVP
MVP

Try this 

COUNT({<ISREAD={0}, [D_DIFF]={'>5'}>} DISPLAYNUMBER)