Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Qlikview check if today have record in a table

Hi,

i am working to build some check mechanism on a table where every day say 20200617, sysdate, it will check table A date field (YYYYMMDD) if there are records. If yes then fail the reload so it will send an email alert. 

My idea is something like 

Count( if( Sysdate = [Date] ) > 1)),

fail

Can anyone help me? Thanks

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Like this?

Count(if(Today()= [Date], 1, 0)) // Here, 1 is record is there and 0 is not there

View solution in original post

1 Reply
Highlighted
Contributor II
Contributor II

Like this?

Count(if(Today()= [Date], 1, 0)) // Here, 1 is record is there and 0 is not there

View solution in original post