Qlik Community

Qlik Sense App Development

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

jblomqvist
Contributor II

SQL table origined field returns the correct answer but gives a minus value?

Hi all,

I have a strange outcome in a table.

When I do Sum(Counter) I get a minus value with the correct answer.

So for example the SQL table may look like:

IDCounter
12121
34341
63421
67221
34971

When I do Sum(Counter) in the UI I am expecting a 5.

However I get a -5

Any idea why?

I tried making sure the counter field is a Num by wrapping the function around the field.

I also did If(Counter = 1, 1,0) but it does not work.

1 Reply

Re: SQL table origined field returns the correct answer but gives a minus value?

Would you be able to share a sample where you are seeing this weird behavior?

Community Browser