Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Abhijitnalekar,
No i try it change the field name. Suppose [Number of Days] .
It's not work.