topic Re: Expression Issue in QlikView

Expression Issue

Anonymous — Mon, 19 Jun 2017 08:49:15 GMT

Below expression works fine if I add this in Expression tab but the same expression gives Error in Calculation error if I add this in dimension

=If (
If(IsNull([Revised Target Completion Date (Issue)]),[Target Completion Date (Issue)], [Revised Target Completion Date (Issue)]) > date(floor((addmonths(vMonthEnd,0))), 'YYYYMMDD')
And If(IsNull([Revised Target Completion Date (Issue)]),[Target Completion Date (Issue)], [Revised Target Completion Date (Issue)]) < date(floor(monthstart(addmonths(vMonthEnd,13))), 'YYYYMMDD')

//If(IsNull(CurrentTargetDate),OriginalTargetDate, CurrentTargetDate) >= date('01/01/2016', 'YYYYMMDD')
,
(date(floor(monthstart(If (IsNull([Revised Target Completion Date (Issue)]),[Target Completion Date (Issue)], [Revised Target Completion Date (Issue)]))), 'MMM-YY'))
)

Re: Expression Issue

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:00:45 GMT

Will you able to provide sample. I assume you required Aggr() over Calc. Dimension

Re: Expression Issue

sunny_talwar — Mon, 19 Jun 2017 10:20:55 GMT

What dimension or dimensions do you use when this is used as an expression? Let's say the dimension is called Dim1, then try this

Aggr(

If (
If(IsNull([Revised Target Completion Date (Issue)]),[Target Completion Date (Issue)], [Revised Target Completion Date (Issue)]) >date(floor((addmonths(vMonthEnd,0))), 'YYYYMMDD')
And If(IsNull([Revised Target Completion Date (Issue)]),[Target Completion Date (Issue)], [Revised Target Completion Date (Issue)]) <date(floor(monthstart(addmonths(vMonthEnd,13))), 'YYYYMMDD')

//If(IsNull(CurrentTargetDate),OriginalTargetDate, CurrentTargetDate) >= date('01/01/2016', 'YYYYMMDD')
,
(date(floor(monthstart(If (IsNull([Revised Target Completion Date (Issue)]),[Target Completion Date (Issue)], [Revised Target Completion Date (Issue)]))), 'MMM-YY'))
),

Dim1)