joining two conditions

[#1]

Hi everyone,

       could you help me adding this condition DEAL_EXTERNALS.created > DEALS.start_date, inside this expression:

Sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) > 1,1,0),USERS.user_id))

thanks

Gerardo

[vincent_ardiet]

Hi,

Have you try to use a AND ?

Like this :

Sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) > 1 and DEAL_EXTERNALS.created > DEALS.start_date,1,0),USERS.user_id))

Regards,

Vincent

[#3]

Hi Vincent,

Yes, i tried…..but the value is 0.

Maybe im doing something wrong with created and start_date dimensión, because the only expression witch give values is:

Sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) > 1 and DEAL_EXTERNALS.created < > DEALS.start_date,1,0),USERS.user_id))

Thanks

gerardo

De: Vincent Ardiet

Enviado el: lunes, 07 de mayo de 2012 10:48 a.m.

Para: Pauza, Gerardo

Asunto: - Re: joining two conditions

QlikCommunity <http://community.qlik.com/index.jspa>

Re: joining two conditions

created by Vincent Ardiet <http://community.qlik.com/people/vincent.ardiet> in New to QlikView - View the full discussion <http://community.qlik.com/message/216814#216814

[vincent_ardiet]

It's hard to give you an answer without your data.

The expression syntax is correct but perhaps that your data model, your data and your business needs can't work with it.

[#5]

Well…..i attached the .qvw file…

Thanks for any advice

De: Vincent Ardiet

Enviado el: lunes, 07 de mayo de 2012 11:08 a.m.

Para: Pauza, Gerardo

Asunto: - Re: joining two conditions

QlikCommunity <http://community.qlik.com/index.jspa>

Re: joining two conditions

created by Vincent Ardiet <http://community.qlik.com/people/vincent.ardiet> in New to QlikView - View the full discussion <http://community.qlik.com/message/216819#216819

[jagan]

Hi,

Did you tried this expression

Sum(Aggr(if(count(DEAL_EXTERNALS.deal_externals_id) > 1 and DEALS.start_date <> DEALS.created,1,0),USERS.user_id))

Regards,

Jagan.

[#7]

sorry.....the expression is wright! i had a mistake in a data model.

thanks jagan and vincent!