topic Re: Exporting in Date Format in QlikView

Exporting in Date Format

Mon, 08 Apr 2013 21:41:15 GMT

I have a chart in which Month is used as dimension. When i export it to Excel i get Month in Date format. I have another chart where two dimensions are used. Product being the primary dimension and Month being Secondary dimension. But when i export this table, month comes in text format. How do i change my month dimension so as to export it in Date format ??

Re: Exporting in Date Format

Tue, 09 Apr 2013 02:30:01 GMT

Try this. Go to go to Settings-->Document Properties-->Number selecte Month from the fields and set it to Date.

Re: Exporting in Date Format

sushil353 — Tue, 09 Apr 2013 02:32:59 GMT

Hi,

Please post the sample app.

HTH

Sushil

Re: Exporting in Date Format

stevedark — Tue, 09 Apr 2013 07:46:17 GMT

Hi there,

I presume that the date you are referring to is the same in both charts? If not, I would look at the load script to ensure this is pulling the date in correctly.

If you have a calculated dimension then this could also alter the format of the field - is your Month dimension calculated or just selected?

What data source are you loading from? If it is a text based file (eg. CSV) then all dates will be loaded as text and you will need to use the Date# function to convert it.

If you can post up some more details we should be able to help further.

Steve

http://www.quickintelligence.co.uk/

Re: Exporting in Date Format

Tue, 09 Apr 2013 09:54:33 GMT

I have attached the sample file.

Re: Exporting in Date Format

Tue, 09 Apr 2013 13:03:23 GMT

I have used same dimension in both the charts and also it is just a selected dimension, not calculated. I have posted a sample file already but i see this message "Currently Being Moderated" in my post.

Re: Exporting in Date Format

stevedark — Tue, 09 Apr 2013 18:42:39 GMT

Hi there - I am seeing the same thing, as you say this is quite strange! If you swap the order of the dimensions around then it also comes through as a date (but gives a strange looking chart).

You could try explicitly forcing to a date when loading from CSV, like this:

Date(Date#(Month_Name,'MMM-YY'),'MMM-YY') as Month_Name,

This is assuming that the format of the date in the CSV file is MMM-YY, adjust the format accordingly if not.

Not sure that this will resolve this though.

When exporting to Excel you can never quite tell what it is going to do. Copying and pasting values seems to work fine.

Steve

Re: Exporting in Date Format

Wed, 10 Apr 2013 06:01:08 GMT

Hi Steve,

Thanks for your reply. But i had already tried this option but this doesn't work properly

Regards,

Sumit