topic Re: Date Comparison Issue-Set Analysis in QlikView

Date Comparison Issue-Set Analysis

Tue, 08 Oct 2013 11:03:34 GMT

Hi All,

I am trying to give this expression in my pivot.

Is there anything wrong with the syntax?Especially the Join_Dt field.Other conditions are working fine .When i give the Join_dt condition its not working properly.

=SUM({<ACTIVE={1},DType={1} ,JOIN_DT={"<$(=(MonthEndDate))"}>}RNK)

Re: Date Comparison Issue-Set Analysis

Tue, 08 Oct 2013 11:08:32 GMT

u can check the date format of both field

Re: Date Comparison Issue-Set Analysis

datanibbler — Tue, 08 Oct 2013 11:09:50 GMT

Hi Poornima,

yes, the syntax in the last part (that JOIN_DT thing) is wrong.

Set_analysis is quite tricky, but I will give it a try.

- What you want is to state that JOIN_DT should be before the MonthEndDate, right?

=> If so, this might work:

>>> =SUM({<ACTIVE={1},DType={1} , JOIN_DT = {"$(= '<' & MonthEndDate)"}>} RNK)

Best regards,

DataNibbler

Re: Date Comparison Issue-Set Analysis

MK_QSL — Tue, 08 Oct 2013 11:10:37 GMT

Try this

SUM({<ACTIVE = {1}, DTYPE = {1}, JOIN_DT = {“<$( =Monthend(Today()) )”}>}RNK)

Re: Date Comparison Issue-Set Analysis

Anonymous — Tue, 08 Oct 2013 11:13:40 GMT

Hello Poornima,

If your are tring to get the last day of the month, use:

sum( {<Date = {'<$(MonthEnd(21/10/2013))'}>} value )

Else, the syntax would be

sum( {<Date = {'<21/10/2013'}>} value )

Hope I could Help. See Attached

Regards

Re: Date Comparison Issue-Set Analysis

Tue, 08 Oct 2013 11:14:29 GMT

Hi Poornima,

try this:

SUM({<ACTIVE={1},DType={1} ,JOIN_DT={"<$(=max(MonthEndDate))"}>}RNK)

Let me know if this helps

Rochelle