topic Sent Date Value To Excel - get Text cell type. in QlikView

Sent Date Value To Excel - get Text cell type.

matancha — Wed, 13 Feb 2013 06:39:05 GMT

Hi.

In my models i hold a variable call "vDF" that representing user date format (On open trigger --> run macro...)

In my models - I'm use calculated dimention: '=Date(Date, vDF)', to show the date according to the user.

My problem is: When i'm send chart to excel, i'm get the calculated dimention from TEXT type.

My question is - How can i send this calculated dimention to excel and get Excel DATE type, in excel worksheet (for group in pivot tables).

Example attached:

Chart with 2 dimention column:

1st column - Date(Date, vDF), When sent to excel --> Excel Text type - That the Problem!!. (I want date type...)

2nd column - "Date" When sent to excel --> Excel Date type - for comparison.

image whith excel's results.

It is possible?

Thanks -

Matan.

er_mohit — Wed, 13 Feb 2013 07:04:30 GMT

hii

try with use of format

that your excel works

date(Datefieldname,'DD-MM-YYYY')

matancha — Wed, 13 Feb 2013 07:12:28 GMT

Thnks er.mohit for your quick answers, but it's not work for me.

Actually-this is what the variable "vDF" does (look at the down-left corner vDF = DD/MM/YYYY).

That's my problem...

Matan.

matancha — Wed, 13 Feb 2013 07:13:35 GMT

in my example, Date is also fieldname...

er_mohit — Wed, 13 Feb 2013 07:27:58 GMT

i can't open your file because i use personal edition

try this

if vDF is variable

then in script write

Date($(vDF) + RowNo() -1) AS TempDate

then it will give you date

make sure you have create theat variable using LET statement i.e vDF

matancha — Wed, 13 Feb 2013 08:19:56 GMT

vDF is set OnOpen trigger (acoording to user OS language).

User doesn't run the script. Server run the script, and users opening the models in server.

Script solution does not help here.

Thnks again -

Matan.