Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load data from CSV and Set analysis


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.

2014-09-30_145704.png

PFA the excel data, and the QVW file.

The same expressions work well if I save the datafile as CSV. Why are the expresssions not working with excel data.

Kindly help me

Thanks,

Deepa V

0 Replies