QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor II

my QV Doc

MVP

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%

File attached.

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

MVP

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

Paul,

Got it. Check the updated attachment below.

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 ?

MVP

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
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 ?

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