topic Re: ErrorFlag in QlikView

ErrorFlag

johnan — Sat, 16 Nov 2024 19:46:29 GMT

Hi all,

I want to flag if my balance with a casepack is uneven.
Balance = 15
Casepack = 12
Balance/Casepack = Uneven (Just give me 1,if uneven or 0 is even)

Is there a smart funtion to that?

Or someone have it 🙂

johnan — Fri, 01 Nov 2019 09:25:19 GMT

ODD i think, 😄

johnan — Fri, 01 Nov 2019 10:10:31 GMT

Hmm, or not?

johnan — Fri, 01 Nov 2019 12:07:23 GMT

I noticed that if my value is 13 it's ok, but if it's 13,5 it doesent work.

sunny_talwar — Fri, 01 Nov 2019 12:21:06 GMT

When you say even, do you mean = 1? or do you mean even as in 2, 4, 6, 8 and odd as in 1, 3, 5?

johnan — Fri, 01 Nov 2019 12:37:06 GMT

Hi, no, i just want to flag if below is ODD

Balance = 15
Casepack = 12

Balance: 15/Casepack (12) = Uneven (1,25) (Give me "Wrong")

Balance: 24/Casepack (12) = Even (2) (Give me "OK")

🙂

sunny_talwar — Fri, 01 Nov 2019 12:51:30 GMT

Oh you mean if there are no decimals? May be this

If(Mod(Balance, Casepack) = 0, 'Even', 'Uneven')