Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

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

Highlighted
Contributor II
Contributor II

yes, the value is a negative number

Highlighted
Creator III
Creator III