Set Analysis issue

[vlad_komarov]

Hello,

My data contains some names and # of days since some event.

I need to create a table chart that displays names only if #days fits in specific range:

<6 months, 6-12 months, 1 - 2 years, etc.

I thought it should be pretty simple, using the expression:

//for < 6 months:

only({<[Name] = {"=min(Days) < $(v6MonthsRange)"}>}[Name])

// for > 8 years:

only(

{<

[Name] = {"=min(Days) >= $(v8YearsRange)"}

>}

[Name])

These two expressions above are working fine.

I have a problems with the same approach for 6-12 months, 1 - 2 years, etc expressions:

only(

{<

[Name] = {"=min(Days) >= $(v1YearRange)"},

[Name] = {"=min(Days) < $(v2YearsRange)"}

>}

[Name])

See the attachment app for details.

What I am missing here?

Regards,

Vladimir

[swuehl · Accepted solution]

Try it like

only(

{<

[Name] = {"=min(Days) >= $(v1YearRange) and min(Days) < $(v2YearsRange)"}

>}

[Name])

[vlad_komarov]

Thanks!

Not super elegant solution (considering Set Analysis other complicated options), but it works!

Regards,

Vladimir