Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, can anyone please help me. I have just noticed that when i export my data into excel it sums up to a different total to my QlikView reports. The problem appears to be that the data in Qlikview is to 3 decimal places but when I export it into excel it rounds up to the nearest integer. Settings on both reports are set to money formatted to £ and no decimal places. Any idea how i resolve this as i can't see any settings to change other than the display format of money?
Did you ever figure this out? I'm facing the same issue. Cheers.
Hi,
You may try with below options specified in this post look at rob reply.
http://community.qlik.com/message/558608#558608
Regards
ASHFAQ
Yep Richard, It was all around the formatting. Stupidly because I had formatted the cells to zero decimal places it exports at zero decimal places and then because you have lost the roundings then it gives you a different total. As such I changed the format to 5dp and it was fine. However, report looks stupid in QV now. Must be a quirk of the system. Frustrating
Thanks Ashfaq