dates issues

Wed, 25 Aug 2010 14:14:35 GMT

Hi guys i'm experiencing a strange proble with the dates.

I have created a calendat using one of the multiple example found into this forum.

On the other side I load valued from an Excel file where dates are stored as numeric value and displayed using date format (cell propertie).

So when i load the XLS file i have this code :

Date([Submitted On]) as SDate,

1 as cpt

and on the calendar side i have

Date(TempDate) AS SDate,

Month(TempDate) AS SMonth

Qlikview link correctly the 2 columns, but the problem occurs when i try to make table using columns from this 2 tables.

For example i try to create a table displaying the columns : Category / SMonth / Sum(Cpt)

The table displays columns Category and Sum correctly at the beginning of the table and columns SMonth contains '-', then when the values from columns Category/Sum(cpt) are ended, table displays the values of SMonth and '-' for the 2 others columns.

I really don't understand why this occurs.

Thanks for your help.

topic dates issues in QlikView

dates issues

Re. :dates issues