Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

adding condition in expression

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

1 Reply
Not applicable

adding condition in expression

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)