Do not make me the sum of an expression if the multiplicity on the other

[#1]

Total: -sum({<[Entry Type]={1},[nPosting_Date]={'>=$(vHaceUno)'}>} Quantity)

Total Real:-sum({<[Entry Type]={1},[nPosting_Date]={'>=$(vHaceUno)'}>} Quantity)*[Quantity per]

Please help me

[kaushiknsolanki]

Hi,

   I dont know this will work or not, but you can try this.

   Total Real:-sum({<[Entry Type]={1},[nPosting_Date]={'>=$(vHaceUno)'}>} Quantity)*sum([Quantity per])

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik,

But dosen't works... Look

[kaushiknsolanki]

Hi,

   What expression you are using to get the first value.

   If possible do upload the qvw file.

Regards,

Kaushik Solanki

[#5]

Yes I send you the file

Thanks

Paco Rios

Organización

prios@engel.es

Móvil: 607362533

Skype: engelaxil-pacorios

Este mensaje es solo para el destinatario y contiene información confidencial. Si recibe por error este mensaje,

ruego lo notifique inmediatamente y elimine el original. Cualquier otro uso de este mail está expresamente prohibido.

De: Kaushik.solanki

Enviado el: miércoles, 06 de julio de 2011 15:04

Para: Paco Rios

Asunto: - Re: Do not make me the sum of an expression if the multiplicity on the other

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

Re: Do not make me the sum of an expression if the multiplicity on the other

created by Kaushik.solanki<http://community.qlik.com/people/kaushik.solanki> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/130607#130607