topic Re: set analysis in QlikView

set analysis

Thu, 07 May 2015 15:35:10 GMT

sum(Montant)-(sum({<Reg_Etat={'Confirmé'},Reg_Mode={'Chèque','Effets'},Reg_Type={'Chèque Impayé'}>}Montant))-sum({<Reg_Etat ={<>'Chèque Impayé'}>}Montant)

Re: set analysis

Gysbert_Wassenaar — Thu, 07 May 2015 15:37:50 GMT

42?

Re: set analysis

Thu, 07 May 2015 15:38:47 GMT

That is the answer but what is the question?

Re: set analysis

awhitfield — Thu, 07 May 2015 15:41:18 GMT

Wise Man says: To get a sensible answer, you need ask a sensible question! Or at lease a question!

Andy

Re: set analysis

Thu, 07 May 2015 15:45:38 GMT

Sorry, cause I need to use different to 'Chèque Impayé', but ther's some mistakes in this expression:

sum(Montant)-(sum({<Reg_Etat={'Confirmé'},Reg_Mode={'Chèque','Effets'},Reg_Type={'Chèque Impayé'}>}Montant))-sum({<Reg_Etat ={<>'Chèque Impayé'}>}Montant)

Re: set analysis

Gysbert_Wassenaar — Thu, 07 May 2015 15:47:01 GMT

Try: sum({<Reg_Etat -={'Chèque Impayé'}>}Montant)

Re: set analysis

stigchel — Thu, 07 May 2015 15:47:39 GMT

Try with

sum({<Reg_Etat =-{'Chèque Impayé'}>}Montant)

Re: set analysis

buzzy996 — Thu, 07 May 2015 15:53:18 GMT

ya,

sum({<Reg_Etat = - {'Chèque Impayé'}>}Montant)