topic Remove Duplicates in QlikView https://community.qlik.com/t5/QlikView/Remove-Duplicates/m-p/93999#M15111 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I Want to remove Duplicates Values from somes Calls in my Application. Here ist the Description:</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Description:</STRONG></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><OL style="list-style-type: decimal;"><LI>Duplicates must be removed only for Automatic and Manual (not for Info)</LI><LI>Automatic is counted as not a duplicate in case an Info Call happened before</LI><LI>Automatic is acknowledged as Duplicate if:<BR /> - there is less than one hour to the previous Automatic for the same VIN<BR /> - there is no info call between the automatic and the previous automatic for the same VIN</LI><LI>Manual is acknowledged as Duplicate if:<BR /> - there is less than one hour to the previous Manual for the same VIN</LI></OL><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Here are some examples</SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Mo 00:40</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:41</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:45</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Mo 01:05</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 01:10</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="342"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD><TD colspan="2" style="border: #000000; border-image: none;" width="224"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD><TD colspan="2" style="border: #000000; border-image: none;" width="224"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automat</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD><TD colspan="2" style="border: #000000; border-image: none;" width="224"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Sa 23:50</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Sa 23:52</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:05</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="470"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automat:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Mo 00:40</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:41</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 01:42</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="470"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automat:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual Mo 00:40</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual Mo 00:41</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual Mo 01:42</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="470"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> Can someone help me please? </SPAN></P><P></P><P></P><P></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">Regards, </SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">William </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 31 Oct 2018 07:24:12 GMT Anonymous 2018-10-31T07:24:12Z Remove Duplicates https://community.qlik.com/t5/QlikView/Remove-Duplicates/m-p/93999#M15111 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I Want to remove Duplicates Values from somes Calls in my Application. Here ist the Description:</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Description:</STRONG></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><OL style="list-style-type: decimal;"><LI>Duplicates must be removed only for Automatic and Manual (not for Info)</LI><LI>Automatic is counted as not a duplicate in case an Info Call happened before</LI><LI>Automatic is acknowledged as Duplicate if:<BR /> - there is less than one hour to the previous Automatic for the same VIN<BR /> - there is no info call between the automatic and the previous automatic for the same VIN</LI><LI>Manual is acknowledged as Duplicate if:<BR /> - there is less than one hour to the previous Manual for the same VIN</LI></OL><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Here are some examples</SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Mo 00:40</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:41</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:45</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Mo 01:05</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 01:10</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="342"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD><TD colspan="2" style="border: #000000; border-image: none;" width="224"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD><TD colspan="2" style="border: #000000; border-image: none;" width="224"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="105"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automat</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="118"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD><TD colspan="2" style="border: #000000; border-image: none;" width="224"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Sa 23:50</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Sa 23:52</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:05</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="470"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automat:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info Mo 00:40</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 00:41</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automatic Mo 01:42</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="470"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: aqua; font-size: 12pt; font-family: Calibri;">Info:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: fuchsia; font-size: 12pt; font-family: Calibri;">Automat:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext; border-image: none;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual Mo 00:40</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual Mo 00:41</SPAN></P></TD><TD style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual Mo 01:42</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></P></TD></TR><TR><TD colspan="3" style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="470"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Total:</SPAN></P></TD></TR><TR><TD style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; background: yellow; font-size: 12pt; font-family: Calibri;">Manual:</SPAN></P></TD><TD style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0px 5.4pt;" valign="top" width="157"><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> Can someone help me please? </SPAN></P><P></P><P></P><P></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">Regards, </SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">William </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Wed, 31 Oct 2018 07:24:12 GMT https://community.qlik.com/t5/QlikView/Remove-Duplicates/m-p/93999#M15111 Anonymous 2018-10-31T07:24:12Z Re: Remove Duplicates https://community.qlik.com/t5/QlikView/Remove-Duplicates/m-p/94000#M15112 <HTML><HEAD></HEAD><BODY><P>see also:</P><P></P><P><A href="https://community.qlik.com/thread/318597">Remove Duplicates</A></P><P></P><P><A href="https://community.qlik.com/thread/318598">Remove Duplicates</A></P></BODY></HTML> Sun, 04 Nov 2018 21:15:44 GMT https://community.qlik.com/t5/QlikView/Remove-Duplicates/m-p/94000#M15112 MarcoWedel 2018-11-04T21:15:44Z