topic Problem in date format in QlikView

Problem in date format

farheenayesha — Wed, 12 Dec 2012 10:30:50 GMT

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.

Re: Problem in date format

Gysbert_Wassenaar — Wed, 12 Dec 2012 11:09:20 GMT

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.

Re: Problem in date format

farheenayesha — Wed, 12 Dec 2012 11:38:56 GMT

Thank you so much for the solution Gysbert.