Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

Calculated Dimension in Bar Chart exports as text to Excel

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

 

 

 

 

 

1 Solution

Accepted Solutions
NitinK7
Specialist
Specialist

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.

View solution in original post

3 Replies
settu_periasamy
Master III
Master III

Hi,

Have you tried to use the date into set expression?

Dimension : [DataLoad date]

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

NitinK7
Specialist
Specialist

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
Creator II
Creator II
Author

Thank you for your response

 

This works perfectly

 

Thank you

Helen