set analysis with date

[bhavvibudagam]

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.

[vishalarote]

Try this hope so it will works

Count(<{Create=">DueDate"},{[Item New String]='Authorised'},{[Item Field] ='Staus'}>IssueNo)

[sasiparupudi1]

Count(if(

(Date#(Created,'DD/MM/YYYY') >Date#(DueDate,'DD/MM/YYYY'))AND [Item New String]='Authorised' AND[Item Field] ='Staus',IssueNo))

[jonathandienst]

How about this?

=Sum({<[Item New String] = {'Authorised'}, [Item Field] = {'status'} >} -(Create > DueDate))

*Assumes that Create and DueDate are normal Qlikview numerical date values.

[Anonymous · Accepted solution]

Hi Bhavani,

Try this file.