Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reading SAP data that is positive and negative

We are reading data from an excel file derived from SAP which contains customer sales data that is both positive (=sales) and negative (=returns). Our problem is that the minus sign comes AFTER the value, and somehow QV doesn't regognize this - thus giving us a net sales total for the customer that doesn't take returns into account.

I'm confessing to being somewhat new to QV still, so my humble question is - HELP! 🙂

2 Replies
johnw
MVP
MVP

num#('12-') appears to return the number -12

Not applicable
Author

Thanks for your suggestion John!

We managed to get around the problem my manually applying a formula in Excel, which moved the sign from the end to the front, but I suspect your solution would be a more automated one.