Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

Help Getting Even Number For Result

Hello:

I need a little bit of help with an expression I'm trying to create that will return an Even number when the result is odd by simply adding 1 (one) to the result, otherwise, leave the result as is if it's already an even number.  For example, if the result is 3, I want to add 1 to it in order to make it 4, if result is 7 add 1 to make it 8, if result is 10, leave it as 10.

The expression I'm trying but which has some type of error (guessing a syntax error) is the following:

=If(Odd(Sum(CPU2) / Count([Host Name])), =Sum(CPU2) / Count([Host Name]) +1)

I think I'm close, and just missing something simple or so I hope.  As always, thanks in advance for any and all help and responses.

1 Solution

Accepted Solutions
Highlighted

Re: Help Getting Even Number For Result

To change your expression so it always returns an even number, wrap it in Round(x, 2):

Round(Sum(CPU2) / Count([Host Name]), 2)

View solution in original post

4 Replies
Honored Contributor III

Re: Help Getting Even Number For Result

'=' in the middle might be giving syntax error -


=If(Odd(Sum(CPU2) / Count([Host Name])), Sum(CPU2) / Count([Host Name]) +1)

Highlighted
Partner
Partner

Re: Help Getting Even Number For Result

Hello Digvijay:

Thanks for the response. You’re right.  Removing the “=” in the middle did indeed fix the syntax error. Thanks for that.

When the expression executes though after saving the update, I get no results.  I get an empty table like the following:

 

If I change the expression to Sum(CPU2) / Count([Host Name]), I get the following table.  I'm not worried about the N/A's at the moment.  I'll clean them up later.  I'm wanting the 3's to be 4's and the 21's to be 22's.

As an FYI, I won't be able to look at this again, most likely, until tomorrow.

 

 

Highlighted

Re: Help Getting Even Number For Result

To change your expression so it always returns an even number, wrap it in Round(x, 2):

Round(Sum(CPU2) / Count([Host Name]), 2)

View solution in original post

Highlighted
Partner
Partner

Re: Help Getting Even Number For Result

Hello Nicole:

Wow.  So simple.  I was obviously thinking I needed to use the Odd function and another Sum expression, but your solution is so much more simple.  I was over-complicating it.  One of these days, I'll know the correct functions to use.  There's a lot of them, but that's part of the power of Qlikview.

Thank you very much for your help.  It is appreciated.  I will mark your answer as correct.  Thanks again.