topic Re: set Analysis Expression in QlikView

set Analysis Expression

mario-sarkis — Tue, 17 Mar 2015 08:17:43 GMT

hey ALL

i have a problem in how to write the following expression :

i have two field first one is the 'clientID' and the seconde field is the 'Destination ClientID'.

there is a transfer of produts between the 'clientID' and the 'Destination ClientID' , i need to calculate the Sum of Products transfered but with condition that the 'Destination ClientID' should be Different then The ClientID (to disregard the transfer between the sameIDs) i need to calculate id without using a Variable if it's Possible .

Help

Thanks

Re: set Analysis Expression

maxgro — Tue, 17 Mar 2015 08:26:50 GMT

maybe a sum/count if

sum(if (client1<> client2, product))

Re: set Analysis Expression

simsondevadoss — Tue, 17 Mar 2015 10:09:53 GMT

if( [Destination ClientID] <> ClientID ,sum(product))

Re: set Analysis Expression

Tue, 17 Mar 2015 10:59:25 GMT

Please Try this Expression and let me Know

if(Sum(Product)<> [client ID] , [Destination ID])

if(Sum(Product)< [client ID] , [Destination ID])

Re: set Analysis Expression

mario-sarkis — Tue, 17 Mar 2015 12:10:03 GMT

HI Navven,

this is wut exactly worked with me

Check this Document: set_analysis_intra-record.qvw