Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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
Valued Contributor II

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

my QV Doc

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

Hi,


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

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

Capture.PNG

File attached.

paulyeo11
Valued Contributor II

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

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

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

Paul,

Got it. Check the updated attachment below.

paulyeo11
Valued Contributor II

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

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 ?

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

Paul, 

Can you post the application where you find mismatch.?

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

Hi,

Use

num(expression,'Your Required Format')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
paulyeo11
Valued Contributor II

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

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
Valued Contributor II

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

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

Community Browser