topic Re: Calculate number of holidays between selected date and last present date in QlikView

Calculate number of holidays between selected date and last present date

nuwanhwb87 — Thu, 14 Oct 2021 08:53:39 GMT

Hi,

I'm Calculating number of holidays between the selected date and last present date of an employee .

Date(vMinDate) :- Selected Date

IN_DATE :- dates worked

In a Holiday ISHOLIDAY Column is "YES"

i have attached the expression below . it gives an error of Bad Field Names [Num] in the top of expression.

In the expression if i use a number like 1,2,3.. instead of [Num] Field it works correctly.

[Num] Is a Expression field created in the table to get the date difference with the selected date and the maximum present Date.

I need to get the answer of [Num] field to here.

Please instruct.

abhijitnalekar — Thu, 14 Oct 2021 09:16:00 GMT

On initial findings, it looks like Qlik assuming Num as a function.

can you please rename the Num field or variable and try agian

nuwanhwb87 — Thu, 14 Oct 2021 10:18:11 GMT

Hi Abhijitnalekar,

No i try it change the field name. Suppose [Number of Days] .

It's not work.