Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bcline2010
New Contributor III

Send to Excel date format inconsistency

I have two objects with the exact same data.  One is a combo chart, the other a straight table.  When I “send to excel” each object, the straight table retains its date format (Sep 2011).  However, the combo chart date changes to a numeric format (40787). 

Aside from formatting the date as text, how do I retain the correct date format with the combo chart?  Why does this work properly for one object and not another?  Perhaps a bug?

1 Reply
bcline2010
New Contributor III

Send to Excel date format inconsistency

Assuming this is WAD and will change my date format to force the text formatting when data is sent to excel. 

text(MonthName(Date))

Community Browser