Qlik Community

Ask a Question

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 
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 Solution

Accepted Solutions
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

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)

View solution in original post

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

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)

View solution in original post