Discussion Board for collaboration related to QlikView App Development.
I have below expression work fine for last 8 yr :-
=if((column(1)+column(2))=0,0,(if(fabs(column(1))=0,1,column(2) / column(1)-1)))
Now i need to measure net profit , when LY value can be -ve and CY value can be +ve i start to encounter issue.
it is possible to make display of -278% change to +278% ?
After i open the QV Doc you file attach , i notice that the % sign is +vie , but for SOURCE = KL , still need it display -ve , because the net profit is lower.
It is not about format issue, it is about when last yr exp is more and current yr exp is less , now it display as +ve , it should be -ve.
Sent from my iPhone