As part of Qlikview to Qliksense few fields are fields are not working in QS as like Qlikview; When adding as dimension in QS it is working but when a

[shanmathytitu]

As part of Qlikview to Qliksense few fields are fields are not working in QS as like Qlikview; i have two issues mentioned below

1. for all these below derivations Qlikview is providing results but QS shows Zero. (original field used for derivation provides data results)

if(Isnull(Round((TOT_CFX_ANNL_MLGE_NUM/CFX_VEH_CNT),1)), 0,   Round((TOT_CFX_ANNL_MLGE_NUM/CFX_VEH_CNT),1))

if(IsNull(Round(TOT_POL_DRVR_AGE_NUM/DRVR_CNT, 1)), 0,   Round(TOT_POL_DRVR_AGE_NUM/DRVR_CNT, 1))

if(isnull(Round(TOT_MVR_POINT_CNT/DRVR_CNT, 1)), 0,   Round(TOT_MVR_POINT_CNT/DRVR_CNT, 1))

if(IsNull(Round(PRM_WGHTED_AVG_DRVR_AGE_SCORE_FCT,0.001)), 0,   Round(PRM_WGHTED_AVG_DRVR_AGE_SCORE_FCT,0.001))

if(IsNull(Round(PRM_WGHTED_AVG_DRVR_ATRCT_SCORE_FCT,0.01)), 0,   Round(PRM_WGHTED_AVG_DRVR_ATRCT_SCORE_FCT,0.01))

if(IsNull(Round(PRM_WGHTED_AVG_MVR_SCORE_FCT,0.01)), 0,   Round(PRM_WGHTED_AVG_MVR_SCORE_FCT,0.01))

if(Isnull(Round(TOT_PRM_WGHTED_AVG_PRICE_MDL_SCORE_FCT,0.001)), 0,           Round(TOT_PRM_WGHTED_AVG_PRICE_MDL_SCORE_FCT,0.001))

if(IsNull(Round((PRBLM_DRVR_CNT/DRVR_CNT)*100, 1)), 0,   Round((PRBLM_DRVR_CNT/DRVR_CNT)*100, 1))

if(Isnull(Round(PRM_WGHTED_AVG_CFX_ANNL_MLG_FCT,0.01)), 0,   Round(PRM_WGHTED_AVG_CFX_ANNL_MLG_FCT,0.01))

if(Isnull(Round(PRM_WGHTED_AVG_DNB_LTGN_FCT,0.001)), 0,   Round(PRM_WGHTED_AVG_DNB_LTGN_FCT,0.001))

if(Isnull(Round(PRM_WGHTED_AVG_CFX_EST_CURR_MLG_FCT,0.001)), 0,   Round(PRM_WGHTED_AVG_CFX_EST_CURR_MLG_FCT,0.001))

if(Isnull(Round(PRM_WGHTED_AVG_XPRIAN_INTSCORE_FCT,0.001)), 0,   Round(PRM_WGHTED_AVG_XPRIAN_INTSCORE_FCT,0.001))

if(Isnull(Round(PRM_WGHTED_AVG_INDST_FCT,0.01)), 0,   Round(PRM_WGHTED_AVG_INDST_FCT,0.01))

if(Isnull(Round(PRM_WGHTED_AVG_POL_TNR_FCT,0.01)), 0,   Round(PRM_WGHTED_AVG_POL_TNR_FCT,0.01))

if(Isnull(Round(PRM_WGHTED_AVG_PRI_LS_HSTRY_FCT,0.001)), 0,   Round(PRM_WGHTED_AVG_PRI_LS_HSTRY_FCT,0.001))

sum(PRBLM_DRVR_CNT)

2.When adding as dimension in QS it is working but when adding as a sum(field) is not working but in qlikview it is working fine.

Sum(All_CFX_LORAM_FCT)

Sum(All_DNB_LTGN_SCORE_FCT)

Sum(All_CFX_ECM_FCT)

Sum(All_XPRIAN_INTSCORE_FCT)

Sum(All_SIC_INDST_FCT)

Sum(All_POL_TNR_FCT)

Sum(All_LS_HSTRY_FCT)

Sum(All_TOT_PRICE_MDL_SCORE_FCT)

Can you please assist on the above 2 issues

[marcus_sommer]

It seems that your fields aren't interpreted as numeric values anymore else as strings. For this are various reasons possible, like different regional-settings and/or missing/changed interpretation-variables and/or a changed load-logic (different load-order, connectors, ...).

[shanmathytitu]

What is the solution for this

[shanmathytitu]

Can you please asssit

[marcus_sommer]

I suggest to compare both environment against each other - by starting at the beginning. This means by loading the raw-data and checking the number of records as well as the content of the fields. Usually is a temporary application quite helpful to load and check the data partly - quickly and easy.