topic Re: Need help on Set Analysis in QlikView

Need help on Set Analysis

Fri, 19 Dec 2014 08:18:29 GMT

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

Re: Need help on Set Analysis

isorinrusu — Fri, 19 Dec 2014 09:49:18 GMT

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()'} }>

Re: Need help on Set Analysis

Anonymous — Fri, 19 Dec 2014 22:46:41 GMT

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

Re: Need help on Set Analysis

MarcoWedel — Sat, 20 Dec 2014 01:17:18 GMT

please provide sample data