Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

Use Slider range in an expression

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.

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Joe,

try this

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

Regards,

Antonio

View solution in original post

3 Replies
antoniotiman
Master III
Master III

Hi Joe,

try this

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

Regards,

Antonio

sqlpuzzle
Contributor III
Contributor III
Author

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.

antoniotiman
Master III
Master III

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