weird issue with chart level formatting calculation,pl need help

[#1]

Hi all,

I would request help from someone to resolve the below issuw.

In the attached file you can see a table with many columns.

considering 3 main columns:

1)current option price

2)option

3)diff= 1-2

I need to get the MTM. = Qty* diff.=0000

but I am not getting my MTM zero due to some format error probably as I am restricting the option values decimal places in chart level.

Please can some one guide me what is wrong here??

sahana

[#2]

hi ,

can anyone help on above issue pl??

[Anonymous]

Hi,

your formula is correct.

If you define the number Format for the column diff to decimal with 4 positions you will notice

that diff is mostly not 0 but e.g. 0.0003 etc. So MTM Shows (9) as -25.0000*0.00035 = -8.745

Qlikview internally calculates with the exact number even if shown 0

If you Need MTM = 0 you have to use round (diff: round(diff))

Hope this answers your question.

[SunilChauhan]

hi,

simply goto properties-> number-> select MTM->Money->

add this in text

#,##0;(#,##0.##)

hope this helps

[#5]

hi Rudolf,

thanks for explaining the problem happening with the above issue.

I tried this round (diff: round(diff))... but it shows syntax error, request you to be little elaborate with this expression as ':' is causing a problem and where to use this ??

sahana.

[Anonymous]

Hi,

wow, your Chart has under Properties and General the Option "Separated" (don't know the exact wording)

with that Option set no Change applies. If you Change this Option it should work.

please try.

[jonathandienst]

Rudolf Linder wrote:

... your Chart has under Properties and General the Option "Separated" (don't know the exact wording)...

that would be Detached in the English version

[#8]

yes,its "detached",I checked the box,but still not working

[Anonymous]

really weird

for diff I have the formula: round([Market Price]-"option")) and it works

I tested it with your Version.

What is exactly the error message/probem if you use round?

[#10]

hi,

there is no error actually,I used the same formula,but the MTM doesn't become zero.I have attached the file in which I have done the changes but it still does not work.

Can you please post my version of application in which you mentioned it worked after you tried ???

sahana