I wish to add conditional coloring in my profile but it isn't working
I have two measures in my KPI and I want one measure to be red when it is less than the other measure and if it is greater than it should appear as green.
Please describe which Qlik Sense object do you use?
If you are using KPI object you don't need to add IF statement. In properties tab of object under "Data" you should have for example Avg([Option Trd Cnt15 nnn]) measure. You need to open it and turn "Conditional colors" ON. You can "Add limit" and write expression. It will be enough if you will add second measure Avg([Option Trd Cnt14 nnn]) as proper limitation and set correct colors.
The color of first measure should change depending on second measure value for current selection.
Please describe which Qlik Sense object do you use?
If you are using KPI object you don't need to add IF statement. In properties tab of object under "Data" you should have for example Avg([Option Trd Cnt15 nnn]) measure. You need to open it and turn "Conditional colors" ON. You can "Add limit" and write expression. It will be enough if you will add second measure Avg([Option Trd Cnt14 nnn]) as proper limitation and set correct colors.
The color of first measure should change depending on second measure value for current selection.
