Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elie_issa
Creator II
Creator 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
sunny_talwar

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

elie_issa
Creator II
Creator II
Author

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.

sunny_talwar

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?