topic Re: Odd & Even Problem in QlikView

Odd & Even Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

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')

Re: Odd & Even Problem

Gysbert_Wassenaar — Wed, 20 Jul 2016 10:02:16 GMT

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

Re: Odd & Even Problem

effinty2112 — Wed, 20 Jul 2016 10:06:14 GMT

Hi Anil,

Try

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

Cheers

Andrew

Re: Odd & Even Problem

Anil_Babu_Samineni — Wed, 20 Jul 2016 10:06:20 GMT

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

Re: Odd & Even Problem

Gysbert_Wassenaar — Wed, 20 Jul 2016 10:09:25 GMT

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()))

Re: Odd & Even Problem

effinty2112 — Wed, 20 Jul 2016 10:09:50 GMT

Hi,

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

Re: Odd & Even Problem

Anil_Babu_Samineni — Wed, 20 Jul 2016 10:12:29 GMT

Nice to see, It's working.

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

Re: Odd & Even Problem

effinty2112 — Wed, 20 Jul 2016 10:30:48 GMT

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

all the best

Andrew

Re: Odd & Even Problem

Anil_Babu_Samineni — Wed, 20 Jul 2016 10:32:35 GMT

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

Re: Odd & Even Problem

Wed, 20 Jul 2016 10:33:42 GMT

Hi Anil,

please find the qvw attached.

Thanks.