Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have KPi object
if(today()>duedate,1,0) as DueDateFlag, ----- this expression in script used.
KPI expression:
ount({<DueDateFlag={1},iD-={'3','4'}>}Number)
here logic is greater than due date from today values should count but I have 8 null values it is not counting so how to include that?
Then may be do this
If(Now() > Alt(duedate, Today()-1), 1, 0) as DueDateFlag,
or your DB check should be by truncating the duedate to just date based on your requirement
Hi,
you have null values on which fields ?
due_date field I have null
May be try to change your flag to this
If(Today() > Alt(duedate, Today()-1), 1, 0) as DueDateFlag,
try to change dueflagdate line on the script to this, and use the same expression:
=if(today()>duedate or len(trim(due_date))=0,1,0) as DueDateFlag
still I can see the result with 2less count
actual 53 in Database and in qlik it is showing 51
dB query :
select count(number) from Main_Tbl
where State <> 3 and State <> 4 and GETDATE()>due_date
did you try to uncheck all "suppress null values" options and see if these two lines appears ?
Can you check what GetDate() is giving
Select GETDATE()
From Dual;
and then see what Today() is giving you in QlikView by creating a text box object with =Date(Today())
Are you getting the same values?
DB result : 2018-04-27 17:31:27.733
qlik : 4/27/2018
And due date is not a timestamp, right?