Need help on Set Analysis

[#1]

Hello,

I am trying to load data from excel and i have written the set analysis expression as below:

Launched Qty = count of trackingID along with selected criteria and breakage description is null

Rejected Qty = cout of trackingID with selected breakage description or (all breakage description except null)

reject rate = RejectedQty/Launched Qty.

PFA the excel data, and the QVW file.

The same expressions work well if I save the datafile as CSV

[isorinrusu]

Deepa,

What {<MyField= >} does is that it ignores all the selections done to MyField. That is, it will take all values of MyField independently on your selections.

Therefore, you are not selecting the values of trackingID where breakage description is null, but instead ignoring your selections in breakage description.

Try something like <{BREAKAGE_DESCRIPTION -= {'null()'} }>

[Anonymous]

Hi,

Else try something like: (there may be simpler methods)

Launched Qty:

=sum ( { -<BREAKAGE_DESCRIPTION = {'*'}>} Trackingid) 

This should some over null values of BREAKAGE_DESCRIPTION

Rejected Qty: (if selections are not made on BREAKAGE_DESCRIPTION then sum Trackingid where BREAKAGE_DESCRIPTION are not NULL, else just sum with the given selections)

= if (GetSelectedCount(BREAKAGE_DESCRIPTION) = 0 ,

          sum ( { <BREAKAGE_DESCRIPTION = {'*'}>} Trackingid) ,

          sum (Trackingid)

Best regards Michael

[MarcoWedel]

please provide sample data