17 Replies Latest reply: Jun 1, 2016 5:32 AM by Tamil arasu

# 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

• ###### 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%

File attached.

• ###### 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.

• ###### 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 Sir

Enclosed the my QV Doc.

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

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

Hi apul,

Can you confirm whether the YTD variance % values are correct.? Do you want to change only the negative and positive sign alone.?

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

Hi Tamil

For the first step I want to focus on Sign only. As this is more impt now.

Paul

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

Fine. I have attached a updated file.

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

Hi,

Use

Regards

• ###### 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

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

How many expression do you have???

Regards

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

enclosed my QV Doc , you can see the expression there

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

Sorry bro dont have qlikview install in my machine.

Regards

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

Hi max

you are QV expert why you not having QV ?

basically my eXP all in -ve value , and my net profit if gain +ve value if lost -ve.

% expression as below :-

=if((column(1)+column(2))=0,0,(if(fabs(column(1))=0,1,column(2) / column(1)-1)))

i have issue on net profit % not display correctly, after change the expression below , net profit work fine :-

(column(2)-column(1)) / Fabs(column(1))

Now my eXP not working fine. for example LY exp -200k and CY exp -100K it display as +ve , it should be -ve.

Paul

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

Hi,

Since past 6 month I am not working on qlikview. I am working on another technology.

Get back to your requirement just tell me what is eXP??

It is fieldValue or expression??

try something like

if(not match(columnName,'eXP'),(column(2)-column(1)) / Fabs(column(1)),column(2) / column(1)-1)

Check bracket closing might missed.

Regards,