Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please stop cluttering this site with duplicate posts:
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?
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
The error source could be there in variable definitions you have. Try to share your app with sample data to troubleshoot.