Code

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

HI All ,

Can some one explain what the beow expression is doing ?

=Alt(Count({$<

DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"}

[Log User]),0)

Thanks

Re: Code

Anil_Babu_Samineni — Mon, 21 Nov 2016 07:10:45 GMT

What are these vDD11MonthBack & vDueEndDate

Explanation:-

This expression getting the Count of [Log User] where DueDate >= vDD11MonthBack and vDueEndDate {Here, It counts the value of [Log User] in between of today and yesterdays date for current selection}

Assume

1) vDD11MonthBack = Today()-1

2) vDueEndDate = Today()

Count({$< DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"} >} [Log User])

---

=Alt(Count({$<

DueDate= {">=$(vDD11MonthBack)<=$(vDueEndDate)"}

[Log User]),0)

Finally, if this condition works fine it gives the count or else 0.

Hope this make helpful

topic Re: Code in QlikView

Code

Re: Code