Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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

0 Replies