topic Multiple IF imbricated Qlikview in Francophones

Multiple IF imbricated Qlikview

Wed, 29 Oct 2014 15:15:50 GMT

Hi,

I have a big problem with the IF Condition.
I would like to write (translate) this code :

CASE (D.DOC_TYPE)WHEN 'A' THEN 'Achat'

WHEN 'V' THEN 'Ventes'

END AS 'Type de doc.',

CASE (D.DOC_TYPE)

WHEN 'V'

THEN

CASE (D.DOC_STYPE)

WHEN 'P' THEN 'Pro-forma'

WHEN 'D' THEN 'Devis'

WHEN 'C' THEN 'Commandes'

WHEN '0' THEN 'Avoirs Financiers'

END

WHEN 'A' THEN

CASE (D.DOC_STYPE)

WHEN 'D' THEN 'Demandes de Prix'

WHEN 'C' THEN 'Commandes'

WHEN 'A' THEN 'Avoirs'

WHEN '0' THEN 'Avoirs Financiers'

END

END AS 'Sous type de doc.',

Someone can help me, please, it's very very urgent!!!!!!

Regards

Re: Multiple IF imbricated Qlikview

Anonymous — Wed, 29 Oct 2014 15:26:54 GMT

You can try this:

if(D.DOC_TYPE = 'A', 'Achat', if(D.DOC_TYPE = 'V', 'Ventes')) as [Type de doc.],

if(D.DOC_TYPE = 'V',

if(D.DOC_STYPE = 'P', 'Pro-forma',

if(D.DOC_STYPE = 'D', 'Devis',

if(D.DOC_STYPE = 'C', 'Commandes',

if(D.DOC_STYPE = '0', 'Avoirs Financiers')))

if(D.DOC_TYPE = 'A',

if(D.DOC_STYPE = 'D', 'Demandes de Prix',

if(D.DOC_STYPE = 'C', 'Commandes',

if(D.DOC_STYPE = 'A', 'Avoirs',

if(D.DOC_STYPE = '0', 'Avoirs Financiers')))

)

) as [Sous type de doc.],

Regards,

Gabriel

Re: Multiple IF imbricated Qlikview

maxgro — Wed, 29 Oct 2014 15:29:51 GMT

load * inline [

doc_type, doc_stype

V,P

V,D

V,C

V,O

A,D

A,C

A,A

A,O

];

load

pick(match(doc_type, 'A', 'V'), 'Achat', 'Ventes') as [Type de doc.],

if(doc_type='V', pick(match(doc_stype, 'P', 'D', 'C', 'O'), 'Pro-forma', 'Devis', 'Commandes', 'Avoirs Financiers'),

if(doc_type='A', pick(match(doc_stype, 'D', 'C', 'A', 'O'), 'Demandes de Prix', 'Commandes', 'Avoirs', 'Avoirs Financiers')

)) as [Sous type de doc.]

resident t;

Re: Multiple IF imbricated Qlikview

Wed, 29 Oct 2014 17:13:38 GMT

Thank you for your answer, Mr. Grossi and Mr. Rocha. I'll test them.
But I do not know if you have any answer to this problem ?? :
first Step for Building Dashbord Qlikview (Join, Load, Set, If)

I don't know, where do I start!!!

Thank you again.
Have a nice evening