topic Re: set analysis on Chi2Test_P in QlikView

set analysis on Chi2Test_P

Fri, 05 Apr 2013 09:29:43 GMT

Hi,

Problem in set analysis for following expression.

How can i achive that should not apply any filter of DoseCavityP, DepositionCavityP field in below expression.

Chi2Test_p( Grp, DoseCavityP, aggr(Sum({<DoseCavityP = {$(=Replace(vDoseSelection,'|',','))}>} DebrisLens), Grp, DoseCavityP))

I tried as below but still applying filters

Chi2Test_p( Grp, DoseCavityP, aggr(Sum({<DoseCavityP = {$(=Replace(vDoseSelection,'|',','))}, DoseCavityP=, DepositionCavityP=>} DebrisLens), Grp, DoseCavityP))

Any suggeston on this will be greatly appreciated.

Thanks in advance.

Re: set analysis on Chi2Test_P

sushil353 — Fri, 05 Apr 2013 10:49:02 GMT

Hi Try this:

Chi2Test_p( Grp, DoseCavityP, total(Sum({<DoseCavityP = {$(=Replace(vDoseSelection,'|',','))}, DoseCavityP=, DepositionCavityP=>} DebrisLens), Grp, DoseCavityP))

HTH

Sushil

Re: set analysis on Chi2Test_P

Fri, 05 Apr 2013 10:52:57 GMT

Myself found the solution on this

chi2test_p({$<DoseCavityP=,DemoldCavityP=,DepositionCavityP=,HydCavityP=>}Grp, DoseCavityP,aggr(Sum({1<DoseCavityP = {$(=Replace(vDoseSelection,'|',','))},DemoldCavityP=,DepositionCavityP=,HydCavityP=>} DebrisLens), Grp, DoseCavityP))

Thanks