Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

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)


and in demsion i have left(CLE,4)

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



3 Replies

Re: set analysis with function

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

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

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)

Community Browser