Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
CaiqueEloy1
Contributor II
Contributor II

Expression coloring

Hello, I have an error in the paste expression.

code used: =IF((Sum({$<[COD_RETENCAO_IRRF]={'0588'},ANO_EMISSAO={'2022'}>} VAL_RET_TRIBUTO) / Sum({$<ANO_EMISSAO={'2022'}>} DIRF_0588) ) = 0,GREEN(),RED())

The intention is to divide the two sets of analyzes and if the result is equal to 0 the color in the table will be green,

Thanks

 

 

Labels (2)
2 Replies
edwin
Master II
Master II

what error message are you getting?  is it possible the denominator is 0?  and you are certain the fields you used are all existing fields?

CaiqueEloy1
Contributor II
Contributor II
Author

The code looks ok, the problem is not coloring right...

 

CODE: =IF((SUM({$<[COD_RETENCAO_IRRF]={'8045'},ANO_EMISSAO={'2022'}>} VAL_RET_TRIBUTO) <> SUM({$<ANO_EMISSAO={'2022'}>} DIRF_8045)),RED(),GREEN())

IF THE VALUE IS DIFFERENT BETWEEN THE TWO FIELDS ILLUSTRATED IN THE PRINT, YOU MUST PAINT RED OR GREEN

 

LOOK.PNG