topic set analysis with date in QlikView

set analysis with date

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 10 Apr 2018 06:44:43 GMT

Try this hope so it will works

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

sasiparupudi1 — Tue, 10 Apr 2018 07:07:34 GMT

Count(if(

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

jonathandienst — Tue, 10 Apr 2018 07:31:39 GMT

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 — Tue, 10 Apr 2018 08:01:59 GMT

Hi Bhavani,

Try this file.