Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
usercapricon
New Contributor

Error in expression

Hi all i try this but this shows an error

=If

(

$(vYTD)=1,

'YTD GP ('&Max(Year_U)&'): '&

Num((Sum({<Year_U= {$(vPrevYear)},Month_U=,Quarter_U=>}

RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))

/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM)),'#,##0.0')

&CHR(10)&

'YTD GP ('&(Max(Year_U)-1)&'): '&

Num((Sum({<Year_U= {$(vPrevYear)},Month_U=,Quarter_U=>}

RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))

/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM)),'#,##0.0')

&CHR(10)&

'Variance  : '& Num((Sum({<Year_U= {$(vMaxYear)},Month_U=,Quarter_U=>}

RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))

/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM) -

Sum({<Year_U= {$(vPrevYear)},UW_Month=,Quarter_U=>}RangeMax(0,RangeMin((PEX_Date- PEff_Date+ 1),($(vPE_Date)- PEff_Date+1)))

/ (PEX_Date- PEff_Date+ 1)*GROSS_PREMIUM)),'##,##0')

)

Error is

Error in express: / is not a valid function