Ignore negative values in input sum expression

[#1]

Hi QlikView folks,

I need small help regarding input sum. I don't want users to enter negative value in inputsum value in a straight table. Is that achievable?

Kindly advise.

Thanks,

Surendra

[#2]

Hi,

I'm sorry are you talking about an input box ?

In that case Input box properties --> Input constraints --> Standard --> Positive Number

Hope it helps

Regards

Giampiero

[#3]

No giampiero...I'm not using input box.

I've declared a field as an input field and used inputsum of that field in a straight table.

What I want to use is when an user enters negative value in the straight table it should take it as a positive value.

[#4]

I see,

at the moment I'm not sure you can do it.

Expression like below

InputSum({$<FieldC={">=0"}>} FieldC)

doesn't admit negative value.

I'm trying to see if it's possible to change value from negative to positive.

Regards

Giampiero

[#5]

Hi Giampierio,

I tried this expression, but its showing "0" when the value is negative.

Is it possible to show message box, when the negative values are entered.

Pls suggest..

[#6]

Hi,

I know. unfortunately the expression I gave you is the maximum I can do with InputSum.

I don't think is possible to show a message.

I'm sorry.

I'll try to see if I can find a workaround

Regards

Giampiero