weekday function not working

[ali_hijazi]

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

[Ruggero_Piccoli]

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:

1. 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.
2. 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

[ali_hijazi]

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

[ali_hijazi]

this is the template

[ali_hijazi]

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

[Ruggero_Piccoli]

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