topic Re: Use Slider range in an expression in QlikView

Use Slider range in an expression

sqlpuzzle — Wed, 19 Jul 2017 19:57:51 GMT

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.

Re: Use Slider range in an expression

antoniotiman — Wed, 19 Jul 2017 20:44:15 GMT

Hi Joe,

try this

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

Regards,

Antonio

Re: Use Slider range in an expression

sqlpuzzle — Wed, 19 Jul 2017 22:30:50 GMT

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.

Re: Use Slider range in an expression

antoniotiman — Thu, 20 Jul 2017 04:26:30 GMT

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