as some others, I'm trying to use a Date Field from Qlik-Sense inside a Pixel-Perfect Table.
This seems to be a Problem inside N-Printing.
I can not get the Date-Field from Qlik sense as Text, because adding Tables with a dimension beginning with "=" (as in "=text(Datefield)") is not possible in N-Printing.
What can I do? The Datefield ist displayed as "dd45222M". If I deselect a String Format, It's just "45222".
It is not true that you cannot get date as text from Qlik Sense. You can do this but you need to create text field directly in your load script as a separate field and use that as a dimension in the table.
Text(Date(YourDateField,'DD.MM.YYYY')) as Date_Text - note that 'DD.MM.YYYY' can be replaced with date format you need.
That is the only way of achieving this and was already discussed on multiple occasions here on community, for example:
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
It is not true that you cannot get date as text from Qlik Sense. You can do this but you need to create text field directly in your load script as a separate field and use that as a dimension in the table.
Text(Date(YourDateField,'DD.MM.YYYY')) as Date_Text - note that 'DD.MM.YYYY' can be replaced with date format you need.
That is the only way of achieving this and was already discussed on multiple occasions here on community, for example:
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
