topic Re: Date-Format in Pixel-Perfect Table (inside Level) in Qlik NPrinting

Date-Format in Pixel-Perfect Table (inside Level)

dnl_kln — Tue, 24 Oct 2023 08:54:26 GMT

Hello,

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".

Any ideas?

Re: Date-Format in Pixel-Perfect Table (inside Level)

Lech_Miszkiewicz — Tue, 24 Oct 2023 09:08:55 GMT

Hi @dnl_kln

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

Re: Date-Format in Pixel-Perfect Table (inside Level)

dnl_kln — Tue, 24 Oct 2023 09:11:39 GMT

Again - thank you @Lech_Miszkiewicz !

Re: Date-Format in Pixel-Perfect Table (inside Level)

Lech_Miszkiewicz — Tue, 24 Oct 2023 10:52:34 GMT

No problem @dnl_kln 🤙