# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Creator III

## Code

HI All ,

Can some one explain what the beow expression is doing    ?

=Alt(Count({\$<

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

>}

[Log User]),0)

Thanks

1 Solution

Accepted Solutions

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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.