topic set analysis with between in QlikView

set analysis with between

Fri, 22 Mar 2013 12:44:29 GMT

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])

Re: set analysis with between

Gysbert_Wassenaar — Fri, 22 Mar 2013 12:49:18 GMT

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.

Re: set analysis with between

Fri, 22 Mar 2013 13:41:38 GMT

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