topic Load data from CSV and Set analysis in QlikView https://community.qlik.com/t5/QlikView/Load-data-from-CSV-and-Set-analysis/m-p/723741#M259670 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>I am trying to load data from excel and i have written the set analysis expression as below:</P><P> Launched Qty = count of trackingID along with selected criteria and breakage description is null</P><P>Rejected Qty = cout of trackingID with selected breakage description or (all breakage description except null)</P><P>reject rate = RejectedQty/Launched Qty.</P><P><IMG alt="2014-09-30_145704.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67923_2014-09-30_145704.png" /></P><P></P><P>PFA the excel data, and the QVW file.</P><P></P><P>The same expressions work well if I save the datafile as CSV. Why are the expresssions not working with excel data.</P><P>Kindly help me</P><P></P><P>Thanks,</P><P>Deepa V</P></BODY></HTML> Tue, 30 Sep 2014 08:07:54 GMT 2014-09-30T08:07:54Z Load data from CSV and Set analysis https://community.qlik.com/t5/QlikView/Load-data-from-CSV-and-Set-analysis/m-p/723741#M259670 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>I am trying to load data from excel and i have written the set analysis expression as below:</P><P> Launched Qty = count of trackingID along with selected criteria and breakage description is null</P><P>Rejected Qty = cout of trackingID with selected breakage description or (all breakage description except null)</P><P>reject rate = RejectedQty/Launched Qty.</P><P><IMG alt="2014-09-30_145704.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67923_2014-09-30_145704.png" /></P><P></P><P>PFA the excel data, and the QVW file.</P><P></P><P>The same expressions work well if I save the datafile as CSV. Why are the expresssions not working with excel data.</P><P>Kindly help me</P><P></P><P>Thanks,</P><P>Deepa V</P></BODY></HTML> Tue, 30 Sep 2014 08:07:54 GMT https://community.qlik.com/t5/QlikView/Load-data-from-CSV-and-Set-analysis/m-p/723741#M259670 2014-09-30T08:07:54Z