topic Re: weekday function not working in Qlik NPrinting

weekday function not working

ali_hijazi — Tue, 19 Dec 2023 12:18:16 GMT

Hello
got a simple report in excel format; I have a field called ENTRY_DATE I added a new formula with the following definition:
weekDay(ENTRY_DATE)
I added this formula to a new column but it always gives null or blank
while this function works in Qlik but in Nprinting designer not

kindly advise

Re: weekday function not working

Ruggero_Piccoli — Tue, 19 Dec 2023 13:06:41 GMT

Hi,

In similar cases post also a screenshot of the template. You added the formula only on the first row and it is not replicated on the other. To have the Excel native formula in all rows of the final report you can:

create a native Excel table that includes the column with the formula. Details are explained in the help site page https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm. I strongly suggest to use this approach because the report generation is faster.
add the source straight table in the Levels node, re-create the table in Excel using levels and add the new calculated column. Explained in details in the same page as before it is slower, so not suggested.

Best Regards,

Ruggero

Re: weekday function not working

ali_hijazi — Tue, 19 Dec 2023 13:36:20 GMT

I'm not creating a pivot table but rather a simple straight table
I made a page for each employee
I'm dragging the formula to the second row after the header

Re: weekday function not working

ali_hijazi — Tue, 19 Dec 2023 13:40:13 GMT

this is the template

Re: weekday function not working

ali_hijazi — Tue, 19 Dec 2023 14:26:54 GMT

now that formulas are not working
how can I change the format of the ENTRY_DATE to MM/DD?

Re: weekday function not working

Ruggero_Piccoli — Thu, 21 Dec 2023 10:54:21 GMT

Hi,

Now I understand that you are using the Qlik Sense WeekDay() formula. You can also use the same Excel formula and format the cells to display the result as day name:

Formatting the original date can be done by using the Excel formatting features but date in Qlik are duals so, if they are interpreted by Excel as text, the cell format is not applied. You can format them in the source table and force the output as Text(). Or you can create another formula and specify there the format of the output.

There are some old posts in the community with mani details about working with dates.

Best Regards,

Ruggero