Calculate number of holidays between selected date and last present date

[nuwanhwb87]

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]

Hi @nuwanhwb87 ,

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]

Hi Abhijitnalekar,

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

It's not work.