Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mofqlikproject
Contributor
Contributor

Less than equal to Selected year and month

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

14 Replies
mofqlikproject
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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

if i use year alone it is working

any help

mofqlikproject
Contributor
Contributor
Author

Hi dilip,

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

<= is not working

agigliotti
Partner - Champion
Partner - Champion

I think you should use the below expression:

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


I hope it will fix your problem.

mofqlikproject
Contributor
Contributor
Author

Than you it is working