Problem in date format

[farheenayesha]

In my excel sheet i have only one 'current value' associated with timestamp but in qlikview when i select one particular timestamp its displaying more than one value as shown in the fig below. Please someone help me out to display proper values.

As u can see in excel there is only one current value(4.33) associated with date 11/1/2012 9:30 AM but in Qlikview its dislaying three values(4.33,4,3).

I want only 4.33 to be displayed. Please someone help me out.

[Gysbert_Wassenaar · Accepted solution]

If you change your filter in excel you will see that you have many records with value 4.00 and 3.00 besides the records with value 4.33 (actually 4,33333333333333, press F2 after selecting a cell to see). So qlikview will show 4 and 3 and 4,33333333333333. You can change the display format on Number tab of the properties screen. Check Overide Document Settings and check the Fixed to radio button. You can then choose how many decimals you want.

[farheenayesha]

Thank you so much for the solution Gysbert.