Calculated Dimension in Bar Chart exports as text to Excel

[helen_pip]

Dear Qlikview user

I have searched for a solution to this but the suggested solutions does not quite fit the purpose

I have a bar chart where the dimension is a calculate dimension of:

If([DataLoad date]>='26/03/2020', [DataLoad date])

when the end user exports the table values to excel the field is in text format

* I have tried wrapping the date function around Dataload date but it makes no difference

* I have tried having the date as an expression instead but that does not seem to work

* I cannot restrict my data load in the script as other objects require earlier dates

Can anyone help me achieve a date format in the bar chart so the end user can export the values as a date to excel

Kind Regards

Helen

[settu_periasamy]

Hi,

Have you tried to use the date into set expression?

Dimension : [DataLoad date]

Expression: Sum({< [DataLoad date]={">=26/03/2020"}>}Measure)

[NitinK7 · Accepted solution]

Hi Helen,

if you use calculated dimension as date then after export it will convert to the text format if you change format to date then also it will be show in text format after export

so instead of using calculated dimension you can use 

Dimension : [DataLoad date]

Expression: Sum({< [DataLoad date]={">=26/03/2020"}>}Measure)

there will be same result that you want.

Thanks,

Nitin.

[helen_pip]

Thank you for your response

This works perfectly

Thank you

Helen