set analysis with between

[#1]

Hi!

May be somebody know how to add between condition in set analysys.

With one condition it's work fine:

count(distinct {<[Independent month]={"=[Independent month] = v_MIN_month "}, sale={'>0'} >} [company])

is it possible something like this?:

count(distinct {<[Independent month]={"= v_MIN_month <= [Independent month] <= [dimension month] "}, sale={'>0'} >} [company])

[Gysbert_Wassenaar]

With two variables it usually looks something like this:

count(distinct {<[Independent month]={">=$(v_MIN_month)<=$(v_MAX-month)"}, sale={'>0'} >} [company])

With your [dimension month] it will most like not work at all. A set is calculated once for the entire chart, not per row. So you can't use the dimensions in your chart in modifiers in your set analysis expression.

[#3]

Hi! Thank you for your help!

i try to change (v_MAX-month) for Date(AddMonths(v_MAX, -(v_count_mes - RowNo(TOTAL))),'MMM YYYY')

but it is nothing

only this way give some result:

count (DISTINCT {< sale={'>0'} >} if([dimension month] >= v_MIN_month  and [dimension month] <= [Independent month]

        , [company]  ))

but it is much slowly