topic Understanding in QlikView

Understanding

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

Hi Community,

Can anyone please explain me how the below expression works ? which is the first condition it starts ?
Please need help on understanding this .

=if(IsNull(Dept_Log),

Count(if(Floor(ArrivedDate)=Floor(RecievedDate),Ticket)),

Count({<Dept_Group_log=P(Dept_Log)>}if(Floor(ArrivedDate)=Floor(RecievedDate),Ticket)))

Thanks in Advance

Re: Understanding

smilingjohn — Mon, 06 Jul 2020 13:43:09 GMT

Hi community

Is there another way to write this expression as this is very confusing

Thanks

Re: Understanding

Gysbert_Wassenaar — Mon, 06 Jul 2020 13:43:13 GMT

It counts tickets that have the same ArrivedDate as RecievedDate. In case there is a Dept_Log value for the ticket it will count the tickerts where the Dept_Group_log value is the same as one of the possible Dept_Log values for that ticket. If there is no Dept_Log value for the ticket it will simply count the ticket if the ArrivedDate is the same as the ReceivedDate.

Re: Understanding

smilingjohn — Mon, 06 Jul 2020 14:51:52 GMT

Thanks @Gysbert_Wassenaar

Can we have this expression in simple form ? It would really help