Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis on Chi2Test_P

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
sushil353
Master II
Master II

Hi Try this:

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

HTH

Sushil

Not applicable
Author

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