topic Re: Null Problem in Set Analysis in QlikView

Null Problem in Set Analysis

krishna20 — Thu, 24 Jul 2014 10:09:52 GMT

Hi friends,

I'm having a problem in Null values.

i'm getting total YTD correctly for all companies when disable suppressed null values.

but when i enable suppressed null values.the total getting diference.

I compared data in oracle, the individual comapny details are getting difference with QV.Here is my expression..can anyone pls help me out.how to include values

=if(vOptionCurrency=1,

(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1}>}CS_AMT_LC_1)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3}>}CS_AMT_LC_1))

+(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2}>}CS_AMT_LC_1)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4}>}CS_AMT_LC_1)),

if(vOptionCurrency=3,

(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1}>}CS_AMT_LC_3)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3}>}CS_AMT_LC_3))

+(Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2}>}CS_AMT_LC_3)-Sum({<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4}>}CS_AMT_LC_3))))

Regards

krishna

Re: Null Problem in Set Analysis

Thu, 24 Jul 2014 10:37:40 GMT

Nulls are tricky to handle...

I recomend to check out this link in order to understand them better:

NULL handling in QlikView

Re: Null Problem in Set Analysis

krishna20 — Thu, 24 Jul 2014 10:42:48 GMT

Hi Jose,

I read it.but i'm not able to understand where to apply in my expression.can u please guide me where can i apply .I'm having dimension COMP_NAME in straight table.

Regards

krishna

Re: Null Problem in Set Analysis

krishna20 — Thu, 24 Jul 2014 11:15:54 GMT

Hi Friends,

I'm trying to resolve the null values by using expression ..but not getting any data.

can anyone solve this isssue.

=if(vOptionCurrency=1,

(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1},CS_AMT_LC_1={'*'}>}CS_AMT_LC_1)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3},CS_AMT_LC_1={'*'}>}CS_AMT_LC_1))

+(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2},CS_AMT_LC_1{'*'}>}CS_AMT_LC_1)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4},CS_AMT_LC_1={'*'}>}CS_AMT_LC_1)),

if(vOptionCurrency=3,

(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {1},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {3},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3))

+(Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {2},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3)-Sum({$-<CLM_SETL_DTYear={"$(=Max(CLM_SETL_DTYear))"},CS_EST_TYPE = {4},CS_AMT_LC_1={'*'}>}CS_AMT_LC_3))))

Regards

Krishna