Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gio92
Contributor II
Contributor II

If measure color expression

Hello Qlik community,

 

Can you please help figure out where is the error in this text color expression?

if(Sum(Aggr(count(distinct {$<[PRATICHE.CONSENSO_L1_MKT]={'KO'}>}[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE]))) /
Aggr(count(distinct TOTAL<[PRATICHE.SOTTOCANALE]>[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE]) > 0.50,red(),
if(Sum(Aggr(count(distinct {$<[PRATICHE.CONSENSO_L1_MKT]={'KO'}>}[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE]))) /
Aggr(count(distinct TOTAL<[PRATICHE.SOTTOCANALE]>[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE]) <= 0.50,green()

 

Thanks in advance

1 Solution

Accepted Solutions
anat
Specialist II
Specialist II

closing brackets are missing.

try below one

if(
(Sum(Aggr(count(distinct {$<[PRATICHE.CONSENSO_L1_MKT]={'KO'}>}[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE]))
/
Aggr(count(distinct TOTAL<[PRATICHE.SOTTOCANALE]>[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE])) > 0.50,red(),
green()
)

View solution in original post

3 Replies
Caterina_Fruci
Support
Support

Hello Gio92,

Based on the reported expression, could you please provide a sample app to help you investigate in depth what error you are encountering while using it ?

Thank you!!

 

 

 

anat
Specialist II
Specialist II

closing brackets are missing.

try below one

if(
(Sum(Aggr(count(distinct {$<[PRATICHE.CONSENSO_L1_MKT]={'KO'}>}[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE]))
/
Aggr(count(distinct TOTAL<[PRATICHE.SOTTOCANALE]>[PRATICHE.CODICE_OPPORTUNITY_LI]),[PRATICHE.CANALE_ACQ_CONTRATTO],[PRATICHE.CONSENSO_L1_MKT],[PRATICHE.SOTTOCANALE])) > 0.50,red(),
green()
)

gio92
Contributor II
Contributor II
Author

Thanks