Function count & sum in set analysis - Qlik Community

Report Inappropriate Content · ‎2015-03-24

Hello everyone,

I've got a problem with this expression:

=count(distinct {$*Nondirectifsfrancebrosserie<[CA NET]={"${=sum([CA NET])}>700"},[CODE SOUS-SOUS FAMILLE]={7200,7280}>} [COUNT CLIENT])

Where :

Nondirectifsfrancebrosserie is my favorite

Can someone help me ?

Thanks a lot,

BI

PrashantSangle · ‎2015-03-24

Hi,

What are you trying to do??

Can explain in detail your requirement.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-03-24

Hi,

I am trying to count distinct clients (from my favorite) that have a turnover (CA NET) > to 700€. The [CODE SOUS-SOUS FAMILLE]={7200,7280} is just a sub category of my favorite.

My expression doesn't work..

Regards