topic Help in Set Analysis in QlikView

Help in Set Analysis

Anonymous — Tue, 10 Jan 2012 11:02:50 GMT

Hi All,

Please any one can help me to write the below expression using Set Analysis.

Count(Distinct If(FndCT_SDF_Ctgy = 'Same Day', PRE_AUDIT_ACCT_SCHDL))

/ (Count(Distinct PRE_AUDIT_ACCT_SCHDL) -

Count(Distinct If(FND_TAG = 'Funded' And IsNull(FndCT_SDF_Ctgy), PRE_AUDIT_ACCT_SCHDL)))

Thanks in Advance

Regards,

Ankit

Re: Help in Set Analysis

Miguel_Angel_Baeyens — Tue, 10 Jan 2012 11:15:15 GMT

Hi Ankit,

The expression should look like the following

Count({< FndCT_SDF_Ctgy = {'Same Day'} >} Distinct PRE_AUDIT_ACCT_SCHDL)
/  (Count(Distinct PRE_AUDIT_ACCT_SCHDL) -
Count({< FND_TAG = {'Funded'}, FndCT_SDF_Ctgy = {"=Len(FndCT_SDF_Ctgy) = 0"} >} Distinct PRE_AUDIT_ACCT_SCHDL))

Check parentheses, I may have missed some.

Hope that helps.

Miguel

Help in Set Analysis

Anonymous — Tue, 10 Jan 2012 11:33:22 GMT

Thanks. Will check and revert back..

Help in Set Analysis

vijay_iitkgp — Tue, 10 Jan 2012 11:35:42 GMT

You can also use

Count(Distinct {$<FndCT_SDF_Ctgy={'Same Day'}>} PRE_AUDIT_ACCT_SCHDL)

Count(Distinct {$},PRE_AUDIT_ACCT_SCHDL)

-
Count(Distinct {$<FND_TAG = {'Funded'}, FndCT_SDF_Ctgy= {"=Isnull(FndCT_SDF_Ctgy)"}>} PRE_AUDIT_ACCT_SCHDL)

Help in Set Analysis

Anonymous — Tue, 10 Jan 2012 12:23:12 GMT

Hi Vipul, Miguel,

The isnull part is not working here, for both the Expressions which u guys have provided me.

Please if you can help me

Help in Set Analysis

SunilChauhan — Tue, 10 Jan 2012 12:26:13 GMT

In place of =Isnull(FndCT_SDF_Ctgy) use

$(=Isnull(FndCT_SDF_Ctgy))

Count({< FndCT_SDF_Ctgy = {'Same Day'} >} Distinct PRE_AUDIT_ACCT_SCHDL) / (Count(Distinct PRE_AUDIT_ACCT_SCHDL) - Count({< FND_TAG = {'Funded'}, FndCT_SDF_Ctgy = {"$(=Len(FndCT_SDF_Ctgy)) = 0"} >} Distinct PRE_AUDIT_ACCT_SCHDL))

hope this helps

Help in Set Analysis

Miguel_Angel_Baeyens — Tue, 10 Jan 2012 12:26:21 GMT

Hi,

IsNull() has some reported issues in some hardware, hence the Len() = 0 (which means that the value has no length, so it's null). Is that what you are looking for? Can you post some sample data we can play with? Is FndCT_SDF_Ctgy a literal, a numeric value, is it an expression from another chart?

Regards.

Miguel

Help in Set Analysis

Tue, 10 Jan 2012 12:51:15 GMT

Hi , Try to use this syntax. Count({< FndCT_SDF_Ctgy = {'Same Day'} >} Distinct PRE_AUDIT_ACCT_SCHDL) / (Count(Distinct PRE_AUDIT_ACCT_SCHDL) - Count({< FND_TAG = {'Funded'}, FndCT_SDF_Ctgy = {} >} Distinct PRE_AUDIT_ACCT_SCHDL)) Hope this will help you. Good luck Regards, Nitin Jain

Help in Set Analysis

Anonymous — Tue, 10 Jan 2012 15:25:15 GMT

No even this is not working