table formatting is changed after the check mark on 'Table Formatting' while export the report

K8859 — Thu, 29 Feb 2024 20:17:09 GMT

When i checked the "Table format", the date shown was not correct but without checking the table formatting, the date shown properly. Did any has face this issue. I am using the August 2023 Patch 8-14.139.15

Re: table formatting is changed after the check mark on 'Table Formatting' while export the report

Frank_S — Thu, 29 Feb 2024 22:31:21 GMT

Please test with attached QVF.

Have tested with and without Table Formatting checkbox selected and it works normally.

However if your source data is not true date format, but rather text data ie: 43254. this could be resulting in the output inconsistency.

You can use the data load editor to update number dates to the expected output format.

See this help page for instructions:

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/date-time-interpretation.htm

If you feel you have a defect (ie this has worked before where you've always had numeric source dates), please do start a support case.

Kind regards...

topic table formatting is changed after the check mark on 'Table Formatting' while export the report in Connectivity & Data Prep

table formatting is changed after the check mark on 'Table Formatting' while export the report

Re: table formatting is changed after the check mark on 'Table Formatting' while export the report