Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

farheenayesha
Contributor

Problem in date format

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.

Qvw.bmp

excel1.bmp

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Problem in date format

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.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Problem in date format

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.


talk is cheap, supply exceeds demand
farheenayesha
Contributor

Re: Problem in date format

Thank you so much for the solution Gysbert.

Community Browser