topic Re: Formula Question / Help in QlikView

Formula Question / Help

Thu, 21 May 2015 18:26:45 GMT

Good Afternoon,

I am looking to visualize data and assign a score of sorts to that data.

For example,

IF field "SAGMDOL" is between 0 and 500 = 1, if it is between 501 - 1000 = 2, and if it is >1500 = 3

I want to use this scoring so that I can identify accounts that are at high risk of costing our organization money if we take a low margin deal.

Thanks

Barry

Re: Formula Question / Help

m_woolf — Thu, 21 May 2015 19:10:52 GMT

Your logic is flawed, You are not assigning any value for SAGMDOL between 1001 and 1499.

in script:

if(SAGMDOL > 1500, 3,

if(SAGMODL > 1000, "Whatever:,

if(SAGMDOL > 500, 2,1)))

What if SAGMDOL is negative?

Re: Formula Question / Help

Thu, 21 May 2015 19:18:12 GMT

Mike,

Thank you for replying. I never thought about the negative factor however after consulting with the powers that be... the complete groupings would be,

SAGMDOL <0 - 0 = 0

SAGMDOL 1 - 500 = 1

SAGMDOL 501 - 1000 = 2

SAGMDOL 1001 - 1500 = 3

SAGMDOL 1501 - 2000 = 4

SAGMDOL > 2001 = 5

Re: Formula Question / Help

m_woolf — Thu, 21 May 2015 19:22:44 GMT

in script:

if(SAGMDOL > 2001, 5,

if(SAGMODL > 1500 , 4,

if(SAGMDOL > 1000 , 3,

if(SAGMODL > 500, 2,

if(SAGMDOL > 0, 1,0))))) as Score;

Re: Formula Question / Help

Thu, 21 May 2015 19:25:08 GMT

Thank you so much Mike.

This is a huge help.