CALCULE TOTAL EN EXCLUANT DES VALEUR

[kangkaw]

Bonjour la communauté,

Je souhaite calculer le total de ma donnée XXX en excluant quelque valeur (222,333) sur ma mesure.

est ce que l'expression suivante est correcte : 

Sum({<XXX-={'222','333'}>} TOTAL)

Merci de me suggérer d'autres expressions si vous en avez.

Bien à vous!

[NadiaB · Accepted solution]

Hi @kangkaw 

It is not clear what you are trying to accomplish, are you trying to remove records from the calculation when the field has 222 or 333? is the field a numeric value? A text value?

My suggestion would be to look into the documentation available for Set Analysis:

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Hope it helps.

[kangkaw]

Hello @NadiaB ,

Thank you for your answer. the problem was resolved.

can you pease gat a look on my new topic if you have an idea :

https://community.qlik.com/t5/New-to-Qlik-Sense/Graphique-en-secteur/m-p/1839087/highlight/true#M192...