Odd & Even Problem

[Anil_Babu_Samineni]

Hello Friends,

Can anyone help me here.

I have

Name     Sales    

A               10

B               11

C               20

D               30

I've created straight table, But i want to add one more column which odd & Even numbers

10 - Even - True

11 - Odd - False

I tried this expression

if(Sum(Sales),(odd(Sum(Sales))), 'False',(even(Sum(Sales))), 'True')

[Gysbert_Wassenaar · Accepted solution]

Try this: =if(Odd(sum(Sales)),'Odd',If(Even(Sum(Sales)),'Even'))

[effinty2112]

Hi Anil,

          Try

Pick(Mod(Sum(Sales),2)+1,'Even','Odd')

Cheers

Andrew

[Anil_Babu_Samineni]

Yes, It is working. But, i want to give Color also like if Odd - Green() & Even - Blue()

[Gysbert_Wassenaar]

Click on the + in front of the expression, select BackGround color and use this expression as Definition:

=if(Odd(sum(Sales)),Green(),If(Even(Sum(Sales)),Blue()))

[effinty2112]

Hi,

Pick(Mod(Sum(Sales),2)+1,Blue(),Green())

[Anil_Babu_Samineni]

Nice to see, It's working.

Both expressions are working, But first response is Gysbert. That's why i put the flag his Answer.

[effinty2112]

If you're not fast you're last!!!

all the best

Andrew

[Anil_Babu_Samineni]

Not like that Andrew, I appreciate your nature helping for freshers. That's why we choose the Qlikview

[#10]

Hi Anil,

please find the qvw attached.

Thanks.