topic Re: Expression Error in QlikView

Expression Error

nuwanhwb87 — Sat, 16 Oct 2021 07:31:34 GMT

Hi,

Can i know the error of below expression "Bad Field Name"

In d Expression i need to count number of holidays between Selected Date (vMinDate) and Last Present Date.

Last Present date taken by substracting a number from Selected Date(vMinDate). That number is coming from "[tttt]" Column. if i use a number insted of "[tttt]" this works well.

Please instruct.

Re: Expression Error

MarcoWedel — Sat, 16 Oct 2021 19:36:02 GMT

instead of using the column name 'tttt' try using the expression of this column.

Re: Expression Error

nuwanhwb87 — Mon, 18 Oct 2021 06:12:06 GMT

This is the expression

Date(vMinDate)-Date(AGGR(MAX((IF(Date(IN_DATE)<=Date(vMinDate) AND NOT ISNULL(CHECK_INTIME),IN_DATE))),EMPLOYEE_ID))

but when it used answer gets zero's and one's only.

Please help

Re: Expression Error

tresB — Mon, 18 Oct 2021 06:16:52 GMT

What happens if you ignore the error initially and press ok?

Re: Expression Error

nuwanhwb87 — Tue, 19 Oct 2021 03:09:10 GMT

It get's Zero's and one's as answer.

I'm getting error in expression when i used below formular .

In the below IN_DATE : Working Days

Date(VMinDate) :Selected date in the Calender Object

CHECK_INTIME : When employee entered finger mark when entering to work that time will display here

MAX((IF(Date(IN_DATE)<=Date(vMinDate) AND NOT ISNULL(CHECK_INTIME),IN_DATE)))

this works superbly in a separate expression and it gives me the Last Present Date.

But when this use to calculate holidays it gives error in Expression.

Please give me a suggessioon of get the maximum IN_DATE as Last Present date. The Correct method of Aggregating this when it use in expression

Re: Expression Error

Branham25 — Wed, 20 Oct 2021 08:07:25 GMT

There are two ways to fix the error:

Go to the Excel workbook and change the name of the sheet called “Hello” back to “Sheet1” or.
In either the Advanced Editor or the Formula Bar edit the M code and replace the reference to “Sheet1” with “Hello” in the second step of the query
AdvancedMD