Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator II
Creator II

Re: Calculated Dimension in Bar Chart exports as text to Excel

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
Highlighted

Re: Calculated Dimension in Bar Chart exports as text to Excel

Hi,

Have you tried to use the date into set expression?

Dimension : [DataLoad date]

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

Highlighted
Creator II
Creator II

Re: Calculated Dimension in Bar Chart exports as text to Excel

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

Highlighted
Creator II
Creator II

Re: Calculated Dimension in Bar Chart exports as text to Excel

Thank you for your response

 

This works perfectly

 

Thank you

Helen