Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

try with something like this: 

 

If(Rank(total sum({<Year={2018}>}[Volume])/sum({<Year={2018}>}total<[Model]>[Volume]))<=Count(total distinct Model & Year),COLOR)