Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
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 Reply
Anil_Babu_Samineni

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

And i recommend you to don't create 2 threads for single issue

Code

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)