Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
alextobias
Contributor II
Contributor II

how to load files with negative values

I have the following information:

account: -4000
account aa: -2000
aaa account: 1000

when it is loaded the result is all positive

account:          4000
account aa:    2000
aaa account: 1000

3 Replies
JustinDallas
Specialist II
Specialist II

Can you try loading the value as a Num?  As in Num(AccountValueField) ?

alextobias
Contributor II
Contributor II
Author

yes, the value is a negative number

jayanttibhe
Creator III
Creator III