Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
Have you tried to use the date into set expression?
Dimension : [DataLoad date]
Expression: Sum({< [DataLoad date]={">=26/03/2020"}>}Measure)
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.
Thank you for your response
This works perfectly
Thank you
Helen