topic Re: Diff between  All, Total & Count in QlikView https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340994#M413098 <HTML><HEAD></HEAD><BODY><P>Save the data in CSV and Upload may be? </P><P></P><P>Just to know is that is question / information?</P></BODY></HTML> Thu, 03 Aug 2017 07:23:41 GMT Anil_Babu_Samineni 2017-08-03T07:23:41Z Diff between All, Total & Count https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340991#M413095 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>While creating dashboard I had understood some important concepts of Qlik View,</P><P>So I wanted to share with you all. Hope it will worth to you.</P><P>Thanks</P><P></P><P><IMG alt="ABC.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172331_ABC.jpg" style="height: 416px; width: 620px;" /></P></BODY></HTML> Thu, 03 Aug 2017 06:49:20 GMT https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340991#M413095 Anonymous 2017-08-03T06:49:20Z Re: Diff between All, Total & Count https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340992#M413096 <HTML><HEAD></HEAD><BODY><P>Rather creating Thread and i would recommend to create Document and update those in version level</P></BODY></HTML> Thu, 03 Aug 2017 06:58:14 GMT https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340992#M413096 Anil_Babu_Samineni 2017-08-03T06:58:14Z Re: Diff between  All, Total & Count https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340993#M413097 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>Total count of data is 13 Lakhs, so it crosses the limit to upload the data.</P></BODY></HTML> Thu, 03 Aug 2017 07:00:31 GMT https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340993#M413097 Anonymous 2017-08-03T07:00:31Z Re: Diff between  All, Total & Count https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340994#M413098 <HTML><HEAD></HEAD><BODY><P>Save the data in CSV and Upload may be? </P><P></P><P>Just to know is that is question / information?</P></BODY></HTML> Thu, 03 Aug 2017 07:23:41 GMT https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340994#M413098 Anil_Babu_Samineni 2017-08-03T07:23:41Z Re: Diff between All, Total & Count https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340995#M413099 <HTML><HEAD></HEAD><BODY><P>Please find the attachment.</P><P></P><P>And try to do the same I have done it on Excel.</P></BODY></HTML> Thu, 03 Aug 2017 09:48:05 GMT https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340995#M413099 Anonymous 2017-08-03T09:48:05Z Re: Diff between All, Total & Count https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340996#M413100 <HTML><HEAD></HEAD><BODY><P>Did you find the answer Anil ?</P><P></P><P><IMG alt="Test 2.jpg" class="jive-image image-1" src="/legacyfs/online/172491_Test 2.jpg" style="height: auto;" />i</P><P></P><P>Dimension : Region</P><P>Total Nbr : Count(GID3)</P><P>Duplicate Sit: Count(GID3)-Count(DISTINCT GID3)</P><P>Duplicate % :&nbsp; =(Count(GID3)-Count(DISTINCT GID3))/((count(TOTAL {&lt;Region&gt;} GID3)-count( DISTINCT&nbsp; TOTAL {&lt;Region &gt;}&nbsp; GID3)))</P></BODY></HTML> Fri, 04 Aug 2017 09:46:59 GMT https://community.qlik.com/t5/QlikView/Diff-between-All-Total-Count/m-p/1340996#M413100 Anonymous 2017-08-04T09:46:59Z