Dates are showing incorrect

[#1]

Hi,

I have a list box with Date. The values are showing fine upto 2013/09/28 but afterwards yit is showing 41564.44683923 and so on.

again after 41564.------  it is showing multiple times the below dates

2013/09/30, 2013/10/01

Could anyone let me know why it is happening.

Thanks.

[#2]

Thanks. I have a column Amount in Transactions table. when I use this column in straight table it's showing blank values. Could you let me know why it is showing blank values but I have link to this Trasactions table.

[saumyashah90]

you cannot use straight table so easily same as table box. You need a proper dimensiona and an expression related to that dimension

[#4]

I used in expression just the column because it will need only column as it contains all values in that column. please help in this

[qlikpahadi07]

its because its not only date its with Date Time

[saumyashah90]

if you need only one column then better take a list box.
If it is a calculated expression then go to expression in a list box and write that expression

[#7]

I need this column appears in straight/pivot table. Is it possible to have the values in straight/pivot table without blanks.

please let me know.

[saumyashah90]

Yes it is possible.

You will need to add proper dimension for that and you need to check your data model for that

For example

That column Transaction which you are calculating needs some fields for the proper out put,you will have add those fields in the dimension table

[#9]

I used the same as you mentioned but still it's showing blank values. please any help. Do I need to change anything.

Thanks.

[saumyashah90]

Can you send the Data model so that i can help you on this.

[#11]

Please have a look on attached and help me