Qlikview check if today have record in a table

DestinedTale — Sat, 16 Nov 2024 00:28:04 GMT

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

Re: Qlikview check if today have record in a table

rockabs — Wed, 17 Jun 2020 10:04:31 GMT

Like this?

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

topic Re: Qlikview check if today have record in a table in QlikView

Qlikview check if today have record in a table

Re: Qlikview check if today have record in a table