topic Re: Expression Error in QlikView

Expression Error

NavinReddy — Mon, 29 Oct 2018 08:28:44 GMT

Hello All,

Below expression is not working form could you please help me to resolve the issue ,

My logic is = 1 and (2 or 3)

=if(Count( {<Month=,QuarterYear=,Year=,[Issue Status Name]={'Open'},[Issue Creation Date]={">=$(vLast2Quarter) <=$(=vCurrentQuarterMaxDate)"}>} [Issue ID])

and

if(Count( {<Month=,QuarterYear=,Year=,[Issue Status Name]={'Completed'},[Issue Creation Date]={">=$(=vCurrentQuarterMaxDate) <=$(=vYourMaxDate)"}>} [Issue ID])

Count( {<Month=,QuarterYear=,Year=,[Issue Status Name]={'Open'},[Issue Creation Date]={">=$(=vCurrentQuarterMaxDate) <=$(=vYourMaxDate)"}>} [Issue ID])))

Thanks in Advance,

Niranjan Pw

Re: Expression Error

tresB — Mon, 29 Oct 2018 08:35:11 GMT

Couple of issues are there I guess. Could you explain your conditional expression in plain English as well?

Re: Expression Error

rubenmarin — Mon, 29 Oct 2018 09:07:55 GMT

This question is duplicated: Expression Error

Re: Expression Error

NavinReddy — Mon, 29 Oct 2018 09:28:57 GMT

i have attached the sample qvw please check

Expression Error