Discussion Board for collaboration related to QlikView App Development.
it is possible ,when i select Negative(Red color) Value that time column name change to Loss and when i select Positive (Green color)Value then it change to profit.
I never tried this before, Even don't have s/w to test. For a while my thought come up as
Below expression should be add for Label of expression with equal sign
=If(Measure < 0, 'Loss', If(Measure >0, 'Profit'))
In qlik, you can't select a figure/expression; you select a field value. If you click on a calculated number and see it is selected, you have actually selected a dimension value. By handling that selection you could probably write a conditional expression for dynamic label. Try to share your sample app to work upon for specific help in details.
Have you tested? If so, Okay
LOAD * INLINE [
Product, CP, SP
A, 100, 150
B, 100, 90
Then Create a straight chart.
Expression label: = if((CP-SP)<0,'Loss',if((CP-SP)>0,'Profit','Loss/Profit'))
You can replace "CP-SP" with your expression.