Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

expression error

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



3 Replies
Gysbert_Wassenaar

Please stop cluttering this site with duplicate posts:

expression error

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?


talk is cheap, supply exceeds demand
capriconuser
Creator
Creator
Author

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

tresesco
MVP
MVP

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