topic Re: joining two conditions in QlikView

joining two conditions

Mon, 07 May 2012 13:30:13 GMT

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

Re: joining two conditions

vincent_ardiet — Mon, 07 May 2012 13:48:04 GMT

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

Re: joining two conditions

Mon, 07 May 2012 14:00:58 GMT

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

Re: joining two conditions

vincent_ardiet — Mon, 07 May 2012 14:07:54 GMT

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.

Re: joining two conditions

Mon, 07 May 2012 14:37:37 GMT

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

Re: joining two conditions

jagan — Mon, 07 May 2012 14:46:57 GMT

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.

Re: joining two conditions

Mon, 07 May 2012 15:01:15 GMT

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

thanks jagan and vincent!