topic Re: weird issue with chart level formatting calculation,pl need help in QlikView

weird issue with chart level formatting calculation,pl need help

Fri, 22 Aug 2014 07:26:29 GMT

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

Re: weird issue with chart level formatting calculation,pl need help

Fri, 22 Aug 2014 08:20:53 GMT

hi ,

can anyone help on above issue pl??

Re: weird issue with chart level formatting calculation,pl need help

Anonymous — Fri, 22 Aug 2014 08:47:12 GMT

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.

Re: weird issue with chart level formatting calculation,pl need help

SunilChauhan — Fri, 22 Aug 2014 08:57:13 GMT

hi,

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

add this in text

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

hope this helps

Re: weird issue with chart level formatting calculation,pl need help

Fri, 22 Aug 2014 08:58:36 GMT

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.

Re: weird issue with chart level formatting calculation,pl need help

Anonymous — Fri, 22 Aug 2014 09:17:05 GMT

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.

Re: weird issue with chart level formatting calculation,pl need help

jonathandienst — Fri, 22 Aug 2014 09:22:50 GMT

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

Re: weird issue with chart level formatting calculation,pl need help

Fri, 22 Aug 2014 09:38:48 GMT

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

Re: weird issue with chart level formatting calculation,pl need help

Anonymous — Fri, 22 Aug 2014 09:49:58 GMT

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?

Re: Re: weird issue with chart level formatting calculation,pl need help

Fri, 22 Aug 2014 10:09:45 GMT

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

Re: Re: weird issue with chart level formatting calculation,pl need help

Anonymous — Fri, 22 Aug 2014 10:18:17 GMT

sure, I hope that it works with your Environment as well

how do i insert a qvw file (it would be my first time)

Re: weird issue with chart level formatting calculation,pl need help

Anonymous — Fri, 22 Aug 2014 10:30:40 GMT

Hi,

I found it, hope that it works!

Re: Re: weird issue with chart level formatting calculation,pl need help

Mon, 25 Aug 2014 03:22:19 GMT

hi Rudolf ,

thanks for the response

The application is partially working.If you check the one attached,when my "option" changes the 'diff" still shows zero. as shown I changes my calender date from 21st to 18th and my option value changes .but the difference is still showing zero it should have .00# difference.

Please can you have a look and guide me?? I guess its getting rounded off.but i want to show the difference till 3 decimal placed atleast.

sahana

Re: Re: weird issue with chart level formatting calculation,pl need help

Mon, 25 Aug 2014 03:55:47 GMT

hi Rudolf,

I tried round(([Market Price]-"option"),0.001) and it works thanks a lot for your help .

sahana