topic Month End Function in QlikView

Month End Function

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm having a problem with the very simple code below?

if ( MonthEnd(dt_ag_closed,0 ) = monthend (dt_processed,0) , 1,0)

All values are being returned as 0 whereas I know there are some 1's where the if statement is true.

Any ideas?

Thanks,

Joseph.

swuehl — Wed, 30 Mar 2016 12:33:17 GMT

How do you know that the if() statement is true for these cases?

What's the format of both fields?

Are both showing a numeric representation?

Do both fields show a unambiguous value within the scope of the if() statement?

Wed, 30 Mar 2016 12:37:09 GMT

I see no problem in your code. Maybe the problem is the format of your fields?

Can you add a sample of data?

sunny_talwar — Wed, 30 Mar 2016 12:45:11 GMT

Can you may be check this:

If(Floor(MonthEnd(dt_ag_closed)) = Floor(MonthEnd(dt_processed)), 1, 0) as Flag

Wed, 30 Mar 2016 14:06:26 GMT

Didn't work

Wed, 30 Mar 2016 14:07:48 GMT

I have a view of the input data and have physically checked.

Both fields are of the format ddmmyyyy8.

Both are numeric.

Not sure what you mean on the last q?

sunny_talwar — Wed, 30 Mar 2016 14:55:10 GMT

Do you have a sample you can share?

swuehl — Wed, 30 Mar 2016 14:58:08 GMT

With the last question I wanted to ask:

In which context (AKA where? a chart? script? text box? Using dimensions? How are fields related?) are you using that expression.

For an expression, you need to use aggregation functions: