topic adding condition in expression in QlikView

adding condition in expression

Mon, 19 Mar 2012 19:53:01 GMT

Hi everyone,

could someone help me to add this condition:

CITIES_SUBSCRIPTIONS.city_id=42556

into this expression:

=aggr(

rangesum( above(Count({$<SUBSCRIPTIONS.is_subscribed = {'1'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>}SUBSCRIPTIONS.email)

-Count({$<SUBSCRIPTIONS.is_subscribed = {'0'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>}SUBSCRIPTIONS.email),0,rowno()))

, CALENDARIO_SUBSCRIPTIONS.AñoMes)

I tried several times but i couldn't.

Thanks a lot

Gerardo

adding condition in expression

Mon, 19 Mar 2012 19:57:39 GMT

well...fighting with this i found something.....i dont know if this is the best way but it help me....

=aggr(

rangesum( above(Count({$<SUBSCRIPTIONS.is_subscribed = {'1'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>} if(match(CITIES_SUBSCRIPTIONS.city_id,42556),SUBSCRIPTIONS.email))

-Count({$<SUBSCRIPTIONS.is_subscribed = {'0'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>} if(match(CITIES_SUBSCRIPTIONS.city_id,42556),SUBSCRIPTIONS.email)),0,rowno()))

, CALENDARIO_SUBSCRIPTIONS.AñoMes)