topic Re: Num Function giving wrong data in QlikView

Num Function giving wrong data

elie_issa — Tue, 31 Oct 2017 13:29:10 GMT

Dear all,

Please find below a screen where i am using the Num function as calculated dimension and as you see the correct answer for the field "Total FOB Local Cur" is JOD but the result shown when using the same field in Num is EGP which is wrong.

Please let me know what will be the best solution for this.

Thanks a lot.

Re: Num Function giving wrong data

sunny_talwar — Tue, 31 Oct 2017 13:34:01 GMT

Would you be able to share a sample to look at this?

Re: Num Function giving wrong data

elie_issa — Wed, 01 Nov 2017 07:31:53 GMT

When i am trying to reduce the dashboard to send you a sample qvw file the data is correct and the field showing EGP is showing JOD.

also when trying to put the calculated dimension as Expression the data shown is also correct.

the main issue is that in my pivot table i am obliged to use it as calculated dimension.

Re: Num Function giving wrong data

sunny_talwar — Wed, 01 Nov 2017 08:43:32 GMT

Have you selected a single Total FOB Local Cur in the above screenshot that you have shared? or have you selected something else.... if you have made some other selection, may be try to create a list box for Total FOB Local Cur to check what all selections are available for this field?