topic What is the function of DISTINCT and NODISTINCT in AGGR function? in QlikView https://community.qlik.com/t5/QlikView/What-is-the-function-of-DISTINCT-and-NODISTINCT-in-AGGR-function/m-p/333430#M122933 <HTML><HEAD></HEAD><BODY><P>What is the function of DISTINCT and NODISTINCT in AGGR function?</P><P>May be someone can explain to me.</P><P></P><P>Thanks,</P><P>Danny H.</P></BODY></HTML> Tue, 03 Apr 2012 03:12:25 GMT 2012-04-03T03:12:25Z What is the function of DISTINCT and NODISTINCT in AGGR function? https://community.qlik.com/t5/QlikView/What-is-the-function-of-DISTINCT-and-NODISTINCT-in-AGGR-function/m-p/333430#M122933 <HTML><HEAD></HEAD><BODY><P>What is the function of DISTINCT and NODISTINCT in AGGR function?</P><P>May be someone can explain to me.</P><P></P><P>Thanks,</P><P>Danny H.</P></BODY></HTML> Tue, 03 Apr 2012 03:12:25 GMT https://community.qlik.com/t5/QlikView/What-is-the-function-of-DISTINCT-and-NODISTINCT-in-AGGR-function/m-p/333430#M122933 2012-04-03T03:12:25Z What is the function of DISTINCT and NODISTINCT in AGGR function? https://community.qlik.com/t5/QlikView/What-is-the-function-of-DISTINCT-and-NODISTINCT-in-AGGR-function/m-p/333431#M122934 <HTML><HEAD></HEAD><BODY><P>Hi Danny,</P><P></P><P>by default aggregation function is Distinct that is when you code </P><P>something like this =aggr(SUM(SALARY) ,Empid ) it means the aggrgation of salary is </P><P>done only on distinct records if you want to do it on repeted records like Empid 1001,1002 repaeting more than once</P><P>and if you need to take this into account then you have to use a keyword NONDISTINCT</P><P></P><P>something&nbsp; like this =aagr(NODISTINCT SUM(SALARY),Empid)</P><P></P><P>then it will sum salary for repeted EmpId</P><P></P><P>Hope you got the point</P><P></P><P>Warm regards,</P><P>Anant Dubey</P></BODY></HTML> Tue, 03 Apr 2012 06:12:33 GMT https://community.qlik.com/t5/QlikView/What-is-the-function-of-DISTINCT-and-NODISTINCT-in-AGGR-function/m-p/333431#M122934 2012-04-03T06:12:33Z