3 Replies Latest reply: Jul 20, 2017 12:26 AM by Antonio Mancini

Use Slider range in an expression

Joe Mathews Jul 19, 2017 3:57 PM

I am trying to get count with a date range slider.The slider is at the month-year level.

Dataset has begin and end date.

The condition is if the begin date (month-year) and end date (month-year) is within the range of the slider selection and I want to include the record in the count. Other wise not include in count.

The sample is attached.

Slider_Range_In_Expression.qvw 224.8 K

Re: Use Slider range in an expression

Antonio Mancini Jul 19, 2017 4:44 PM (in response to Joe Mathews)

Hi Joe,
try this
=Num(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country),'###,##0')

Regards,
Antonio
Like Show 0 Likes (0)

Actions
- Re: Use Slider range in an expression
  
  Joe Mathews Jul 19, 2017 6:30 PM (in response to Antonio Mancini)
  
  Thanks.
  
  How can I add one more condition into the above Expressions.
  
  Like a column called 'approved' That has values 'Y' or 'N'. And I want to include only the approved ='Y' in the above count.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Use Slider range in an expression
    
    Antonio Mancini Jul 20, 2017 12:26 AM (in response to Joe Mathews)
    
    =Num(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'},approved={'Y'}>} country),'###,##0')
    
    Like Show 0 Likes (0)
    
    Actions

Go to original post