topic Re: Error in Expression in QlikView

Error in Expression

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an expression that included variables. I keep getting an error in expression but can't seem to find the issue.

=if(Loc_Status='ONG',sum( $(Set60Days) IdealFlag)/Count(DISTINCT $(Set60Days) CalendarDate))

Variable description below:

Set60Days = {$<CalendarDate = {">=$(v60Days) <=$(vMaxCalDate)"},OPS_MonthYear=>}

v60Days = AddMonths(max(CalendarDate),-2)

vMaxCalDate = max(CalendarDate)

Re: Error in Expression

vishsaggi — Tue, 05 Jun 2018 21:35:39 GMT

What value does your variable Set60Days display when you use $(Set60Days) can you try this in your text object and let me know.

And you cannot use $(Set60Days) in your sum like that. What exactly you are trying to do in your below expr?

I mean sum(IdealFlag) and what is this Set60days doing here are you multiplying ? or doing something else? You might need set analysis is what i think. Please elaborate a little more.

=if(Loc_Status='ONG',sum( $(Set60Days) IdealFlag)/Count(DISTINCT $(Set60Days) CalendarDate))

Re: Error in Expression

poojashribanger — Wed, 06 Jun 2018 05:47:32 GMT

if(Loc_Status='ONG',sum( {<$(Set60Days)>} IdealFlag)/Count({<$(Set60Days)>} DISTINCT CalendarDate))

enclose that variable in set analysis.

Re: Error in Expression

sunny_talwar — Wed, 06 Jun 2018 11:44:01 GMT

I keep getting an error in expression but can't seem to find the issue.

Is that your expression editor says that there is an error or do you see an error/ or see nothing when you click okay on the expression editor and look for the result in the object? The reason I ask this is because, there are times when expression editors don't really understand the syntax and will say that there is an error where there is none. In your case...

=if(Loc_Status='ONG',sum( $(Set60Days) IdealFlag)/Count(DISTINCT $(Set60Days) CalendarDate))

the part in red will def. throw an error in expression editor, but it may still work if the value within that variable is good... which it seems like is (syntax wise).

Re: Error in Expression

taylor_jesse — Wed, 06 Jun 2018 13:58:23 GMT

Same error

Re: Error in Expression

taylor_jesse — Wed, 06 Jun 2018 14:00:58 GMT

Hi,

It shows values but the expression editor says there is an error. I think you are right. I experience that a lot.

Re: Error in Expression

taylor_jesse — Wed, 06 Jun 2018 14:02:21 GMT

The expression works but the editor says error in expression