topic Re: Result based on Derived value. in QlikView

Result based on Derived value.

ajaykumar1 — Thu, 11 Dec 2014 06:15:42 GMT

Hi All,

I want to show the expression 3 result based on the exp1 and exp2(Not their on the original values.)

Here am attached the sample application.

Re: Result based on Derived value.

jyothish8807 — Thu, 11 Dec 2014 06:24:49 GMT

I guess its working fine. What's the issue?

Regards

Re: Result based on Derived value.

ajaykumar1 — Thu, 11 Dec 2014 07:58:55 GMT

Thanks Jyothish,

Let me explain from above:

Exp1-----3% <= exp2---3% so column3 "First"------------------Fine

Exp1-----3% <= exp2---3% so column3 "Second"-----------------wrong(Because getting result based on the 2.96 <= 2.9 .I want result based on after percentage like 3% <= 3%..So it shoulb "First"

Exp1-----8% <= exp2---3% so column3 "Second"------------------Fine(This result also like above explanation)

I hope its clear again.

More Thanks,

Ajay

Re: Result based on Derived value.

jyothish8807 — Thu, 11 Dec 2014 08:19:58 GMT

It is not wrong, go to numbers and change it to fixed 3 then you can see the numbers are fine.

In second case column 1 is 3.96% and Column 2 is 3.90%. So your output is fine. Hope it will help.

Regards

Re: Result based on Derived value.

ajaykumar1 — Thu, 11 Dec 2014 09:10:33 GMT

Your Right...If am did fixed to 3 then i will get result.

But in the real data around 10 digits are there and they keep integer and show in percentage option

So on the percentage result only i have to derive 3 expression.

More Thanks,

Ajay

Re: Result based on Derived value.

morganaaron — Thu, 11 Dec 2014 09:16:42 GMT

If you want it accurate to 1% (as in 0.01) then use the round command, so for column 3 write:

if(Round(Column(1), 0.01) <= Round(Column(2), 0.01), 'First', 'Second')

Re: Result based on Derived value.

jyothish8807 — Thu, 11 Dec 2014 10:10:13 GMT

Hi,

Then as Aaron Mentioned, use round function. or num(Colum(1),'##')

Regards