Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

elie_issa
Contributor II

Num Function giving wrong data

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.

Capture26.PNG

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

Thanks a lot.

3 Replies
Highlighted

Re: Num Function giving wrong data

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

Highlighted
elie_issa
Contributor II

Re: Num Function giving wrong data

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.

Highlighted

Re: Num Function giving wrong data

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?