topic Re: set analysis with function in QlikView

set analysis with function

souadouert — Thu, 14 Dec 2017 15:11:00 GMT

Hello,

i have this problem with this set expression(table)
sum({<CLE,CLE= {"=Left(CLE,4) = '2017'"} ,CLE= {"=mid(CLE,5,2) = '11'"}, COMPTE_TYPE_DEPOT-={"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>}COMPTE_SOLDE_COMPTABLE_TND)

and in demsion i have left(CLE,4)

So , the results is usually 0 with all CLE only 201711

Re: set analysis with function

sunny_talwar — Thu, 14 Dec 2017 15:20:58 GMT

May be try this

Sum({<CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

Re: set analysis with function

Anil_Babu_Samineni — Thu, 14 Dec 2017 15:23:04 GMT

You cannot suppose to use degrade for 1 field like, Use this?

Sum({<CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

Re: set analysis with function

sunny_talwar — Thu, 14 Dec 2017 16:47:48 GMT

I think what you really need is to ignore CLE in your inner expression....

Sum(TOTAL {<CLE= {"=Left(Only({<CLE>}CLE), 6) = '201711' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES", "CARTE", "-", "DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

topic Re: set analysis with function in QlikView

set analysis with function

Hello,

i have this problem with this set expression(table)sum({<CLE,CLE= {"=Left(CLE,4) = '2017'"} ,CLE= {"=mid(CLE,5,2) = '11'"}, COMPTE_TYPE_DEPOT-={"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>}COMPTE_SOLDE_COMPTABLE_TND)

Re: set analysis with function

Sum({<CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

Re: set analysis with function

Sum({<CLE= {"=Left(CLE,4) = '2017' and mid(CLE,5,2) = '11' "}, COMPTE_TYPE_DEPOT -= {"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>} COMPTE_SOLDE_COMPTABLE_TND)

Re: set analysis with function

i have this problem with this set expression(table)
sum({<CLE,CLE= {"=Left(CLE,4) = '2017'"} ,CLE= {"=mid(CLE,5,2) = '11'"}, COMPTE_TYPE_DEPOT-={"AUTRES SOMMES DUES","CARTE","-","DEPOTS BANQUES DINARS"}>}COMPTE_SOLDE_COMPTABLE_TND)