topic Re: Ignore negative values in input sum expression in QlikView

Ignore negative values in input sum expression

Mon, 04 Feb 2013 13:18:25 GMT

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

Mon, 04 Feb 2013 13:30:42 GMT

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

Mon, 04 Feb 2013 13:33:37 GMT

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.

Mon, 04 Feb 2013 14:38:20 GMT

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

Tue, 05 Feb 2013 10:43:40 GMT

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..

Tue, 05 Feb 2013 11:11:01 GMT

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