Less than equal to Selected year and month

[mofqlikproject]

i need to show data until selected year and Month

have Joining date till the selected year moth need to know number of employees

tried build two variables

1.vYear ==passing selected year

2. vMonth =passing selected Month

3. concatenation both variables vyearmonth =vYear &vMonth

have column year(joinng date)&month(joining date)  created this column in database

201901

201902

201903

.

.

.

used below expression but not working

=Count(distinct{<yearmonth=  {"<=$(vyearmonth )"}>} empno)

need urgent

it s beheaving strange

[mofqlikproject]

it  's  not selected date

i need to design two filters one year and one Month

based on selection we need number of employess

[mofqlikproject]

it is not working <= when i concatenate two variables into third variable

if i use year alone it is working

any help

[mofqlikproject]

Hi dilip,

i use the expression you suggested but is giving data for selected year and month

<= is not working

[agigliotti · Accepted solution]

I think you should use the below expression:

Count( {< year =, month =, yearmonth =  {"<=$(=vYearMonth )"} >} distinct empno )

I hope it will fix your problem.

[mofqlikproject]

Than you it is working