Set Analysis - >= of a String Value

[SNarendran]

Hi,

I have a yearmonth field in my script.

It reads like 2017-01.

I want my set analysis expression to give me a count of values from another field when the yearmonth field is >= '2017-01'.

What will my set analysis expression be?

COUNT({<YearMonth_Created ={">= Date#(2017-01)"} >} NL_MLS) doesn't work

[Taoufiq_Zarra]

for the example you have attached, what do you expect as a result on straight table?

[SNarendran]

CreatedDate from 2017-01 and its corresponding MLS count,thanks.Shashank

[Taoufiq_Zarra]

I'm a little confused.
if I understand correctly here you don't need Set Analysis
I attached two versions of the file, one with the values as you requested and another where I linked the two files by the date field and then display the two indicators.
and I don't know if you need a count or sum.

if not, you can attach here an excel file for example where you show exactly what you want (the expected result)

[SNarendran]

Thanks. Count or sum doesn't matter. I am using count in real time.

I see that you have hard-coded'2017-01' in order to filter the Date created dimension:

= if(New_YearMonth_Created>=Date(Date#('2017-01','YYYY-MM')),New_YearMonth_Created)

I need the hard-coded 2017-01 to be the minstring of the sold date.

And the expression to be a count of the new MLS from the Sold table.

[Taoufiq_Zarra]

sorry @SNarendran 
but I can't see the difference between what you sent and what I sent.

in your example I don't know why there are 22 in 01-2017 then what you sent in the dataset is 70.