Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

LY net profit -ve and CY +ve How to make the % column display as +ve % ?

Hi All

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% ?

Paul

17 Replies
paulyeo11
Master
Master
Author

my QV Doc

tamilarasu

Hi,


Go to number tab and select the expression and then change the format pattern like below.

#,##0%;#,##0%

Capture.PNG

File attached.

paulyeo11
Master
Master
Author

Hi Tamil

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.

Paul

tamilarasu

Paul,

Got it. Check the updated attachment below.

paulyeo11
Master
Master
Author

Hi sir

Now net profit is correct , but eXP is wrong . When i change my dimension to eXP , it is possible to make it display correctly ?

tamilarasu

Paul, 

Can you post the application where you find mismatch.?

PrashantSangle

Hi,

Use

num(expression,'Your Required Format')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
paulyeo11
Master
Master
Author

Hi Sir

Enclosed the my QV Doc.

Notice that when you click on button for dimension = eXP , how to make the % sign change to -ve ?

paulyeo11
Master
Master
Author

Hi Max

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