https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1830853#M16372 <P>Hello ! I uploaded an Excel file to Qlik which has 50 "active" and 38 "inactive" but when I create the QlikSense indicator I find 47 and 41. Does anyone have an explanation? Here is the formula used: Count({&lt;Active={'Active'}&gt;} ([JUN-MAR.Active]))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_0-1629816899935.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60641iBC898EF8494612BE/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_0-1629816899935.png" alt="Wal_Riachi_0-1629816899935.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_1-1629816915303.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60642i268B23B228134E0B/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_1-1629816915303.png" alt="Wal_Riachi_1-1629816915303.png" /></span></P><P>&nbsp;</P> Tue, 24 Aug 2021 14:55:21 GMT Waïl_Riachi_Sanofi 2021-08-24T14:55:21Z https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1830853#M16372 <P>Hello ! I uploaded an Excel file to Qlik which has 50 "active" and 38 "inactive" but when I create the QlikSense indicator I find 47 and 41. Does anyone have an explanation? Here is the formula used: Count({&lt;Active={'Active'}&gt;} ([JUN-MAR.Active]))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_0-1629816899935.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60641iBC898EF8494612BE/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_0-1629816899935.png" alt="Wal_Riachi_0-1629816899935.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_1-1629816915303.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60642i268B23B228134E0B/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_1-1629816915303.png" alt="Wal_Riachi_1-1629816915303.png" /></span></P><P>&nbsp;</P> Tue, 24 Aug 2021 14:55:21 GMT https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1830853#M16372 Waïl_Riachi_Sanofi 2021-08-24T14:55:21Z https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1830870#M16373 <P>are you doing any joins in your load script?</P><P>Can you share the excel file &amp; load script?</P> Tue, 24 Aug 2021 15:54:31 GMT https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1830870#M16373 stevejoyce 2021-08-24T15:54:31Z https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1831014#M16374 <P>I didn't use the load script I load directly with the data manager. Here is my joins (by GILES number)</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_1-1629878616779.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60684i68B4219FA2E23BB0/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_1-1629878616779.png" alt="Wal_Riachi_1-1629878616779.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_2-1629878633864.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60685iC7429B22C5AA89FA/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_2-1629878633864.png" alt="Wal_Riachi_2-1629878633864.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Wal_Riachi_3-1629878675208.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60686iBEDE3C9AE7BDEBF6/image-size/medium?v=v2&amp;px=400" role="button" title="Wal_Riachi_3-1629878675208.png" alt="Wal_Riachi_3-1629878675208.png" /></span></P><P>&nbsp;</P> Wed, 25 Aug 2021 08:05:00 GMT https://community.qlik.com/t5/Francophones/Data-recognition-problem/m-p/1831014#M16374 Waïl_Riachi_Sanofi 2021-08-25T08:05:00Z