topic Re: Function IF or IF in expression in QlikView

Function IF or IF in expression

Wed, 02 Mar 2016 08:35:45 GMT

Hello i have a problem with my expression "if or if" maybe you can help me :

i try to calculate an expression with this :

if([Site Facture]= 'PX', (CMSPSX*Qte), [Site Facture]) or if([Site Facture]= 'FV', (CMSFV*Qte), [Site Facture])

but my results is "-1" and i don't know why.

Maybe you can help me ?

I have join an exemple of my problem

Best regards

sunny_talwar — Wed, 02 Mar 2016 15:37:46 GMT

May be this?

if(Match([Site Facture], 'PX', 'FV'), (CMSPSX*Qte), [Site Facture])

sfatoux72 — Wed, 02 Mar 2016 15:39:21 GMT

Use :

Rangesum(if([Site Facture]= 'PX', (CMSPSX*Qte), [Site Facture]), if([Site Facture]= 'FV', (CMSFV*Qte), [Site Facture]))

Wed, 02 Mar 2016 15:39:22 GMT

i have solve my problem with this expression :

If( Site_Facture = 'PX',

sum(CMS*(Qté_Facturé*Coef_UV_US)),

if( Site_Facture = 'FV',

sum(CMSFV*(Qté_Facturé*Coef_UV_US))

))

The problem was the labels, don't working on my function. I have use the full operation.

sfatoux72 — Wed, 02 Mar 2016 15:42:13 GMT

or simply :

Rangesum((CMSPSX*Qte), (CMSFV*Qte))

Rangesum manage null value

sfatoux72 — Wed, 02 Mar 2016 16:00:15 GMT

Or better:

Rangesum(CMSPSX, CMSFV) * Qte