Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I need to count the numbers when Create > DueDate and [String]='Authorised' and [Item Field] ='Staus' in KPi
Please help me to write the expression.
Thanks in advance.
Try this hope so it will works
Count(<{Create=">DueDate"},{[Item New String]='Authorised'},{[Item Field] ='Staus'}>IssueNo)
Count(if(
(Date#(Created,'DD/MM/YYYY') >Date#(DueDate,'DD/MM/YYYY'))AND [Item New String]='Authorised' AND[Item Field] ='Staus',IssueNo))
How about this?
=Sum({<[Item New String] = {'Authorised'}, [Item Field] = {'status'} >} -(Create > DueDate))
*Assumes that Create and DueDate are normal Qlikview numerical date values.
Hi Bhavani,
Try this file.