topic expression error in QlikView

expression error

capriconuser — Mon, 05 Nov 2018 08:23:11 GMT

i am trying to get Earned Premium on the basis of Year

i do this but this shows an error

=If

(

$(vYTD)=1,

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

Num({<UYear = {$(vMaxYear)},UMonth=,UQuarter=>}$(vEarned_Premium)/

pow(1000,floor(log10(fabs({<UYear = {$(vMaxYear)},UMonth=,UQuarter=>}$(vEarned_Premium)))/3)),'#,##0')

& pick(floor(log10(fabs({<UYear = {$(vMaxYear)},UMonth=,UQuarter=>}$(vEarned_Premium)))/3)+1,'',' K',' MN',' BN',' TN')

)

this shows an error on whole expression

Re: expression error

Gysbert_Wassenaar — Mon, 05 Nov 2018 08:31:51 GMT

Please stop cluttering this site with duplicate posts:

expression error

https://community.qlik.com/thread/318871

Does the expression editor indicate an error or does the expression return an error when used in a chart?

Re: expression error

capriconuser — Mon, 05 Nov 2018 10:04:44 GMT

oh this is by mistake .. i post multiple times but website is hang so i though my questions is not posted.. i am going to delete the other 2 one ... sorry for this

and expression editor indicate the error on whole

Re: expression error

tresB — Mon, 05 Nov 2018 10:11:37 GMT

The error source could be there in variable definitions you have. Try to share your app with sample data to troubleshoot.