I have a little problem with my graph, I have duplicate values as dimension and I don't understand why.
It's a graph with date of reloading as dimension that i collect like this :
Date(ConvertToLocalTime(ReloadTime(),'Paris'),'DD/MM/YYYY') as date of reloading.
And as one day i reloaded multiple times i have multiple values of this day as dimension.
I supposed this is because Date is only a function who is useful for displaying date but not really to convert date ? So As ReloadTime contains also hour/ minute / second, the values are different but as they are showed only as DD/MM/YYYY they look the same.
I was so wondering what would be the best way to convert them to dd/MM/yyyy only ?
Date# should work no ? I tried Date(Date#(ConvertToLocalTime(ReloadTime(),'Paris'),'DD/MM/YYYY'),'DD/MM/YYYY') as Date of Reloading, but the result is an empty field
( I checked this https://community.qlik.com/t5/QlikView-App-Dev/reloadtime-format/m-p/709289 )
Thanks for reading