topic Modeling in QlikView https://community.qlik.com/t5/QlikView/Modeling/m-p/867656#M998505 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I am new to QV. </P><P>Hope anybody could help me please !!</P><P></P><P>I have a requirement to build the model and Dashboards</P><P>Requirements : in metrics/KPI's</P><P>1.Count of Unique Stores by User </P><P>2.Count of Unique Users</P><P>3.Total stores visited(actual)</P><P>4.Total stores should be visited</P><P>5.Pending Stores remained to visit</P><P></P><P>Below are the sample tables</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="352"><TBODY><TR><TD colspan="2" height="20" width="220">Main Transaction table</TD></TR><TR><TD class="xl66" height="20">ID</TD><TD class="xl66">User</TD><TD class="xl66">Date</TD><TD class="xl66">Product</TD></TR><TR><TD height="20">abc111</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc111</TD></TR><TR><TD height="20">abc111</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc112</TD></TR><TR><TD height="20">abc112</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc113</TD></TR><TR><TD height="20">abc112</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc114</TD></TR><TR><TD height="20">abc113</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc115</TD></TR><TR><TD height="20">abd114</TD><TD>Sean</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc116</TD></TR><TR><TD height="20">abd114</TD><TD>Sean</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc117</TD></TR><TR><TD height="20">abd115</TD><TD>Sean</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc118</TD></TR><TR><TD height="20">abd116</TD><TD>White</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc119</TD></TR><TR><TD height="20">abc116</TD><TD>White</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc120</TD></TR><TR><TD height="20">abc117</TD><TD>White</TD><TD align="right" class="xl65">4/06/2015</TD><TD>Pdc121</TD></TR><TR><TD height="20">abc117</TD><TD>White</TD><TD align="right" class="xl65">4/06/2015</TD><TD>Pdc122</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD colspan="2" height="20" width="175">Detail(Unique)</TD></TR><TR><TD class="xl65" height="20">ID</TD><TD class="xl65">Store</TD></TR><TR><TD height="20">abc111</TD><TD>Australia</TD></TR><TR><TD height="20">abc112</TD><TD>America</TD></TR><TR><TD height="20">abd114</TD><TD>Dubai</TD></TR><TR><TD height="20">abc116</TD><TD>-</TD></TR><TR><TD height="20">abc117</TD><TD>-</TD></TR><TR><TD height="20">abc118</TD><TD>Thailand</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 169px;"><TBODY><TR><TD colspan="2" height="20" width="169">Lookup(Stores allocated to each user)</TD></TR><TR><TD class="xl65" height="20">User</TD><TD class="xl65">Stores</TD></TR><TR><TD height="20">Lucy</TD><TD>Australia</TD></TR><TR><TD height="20">Lucy</TD><TD>America</TD></TR><TR><TD height="20">Lucy</TD><TD>Austria</TD></TR><TR><TD height="20">Sean</TD><TD>Dubai</TD></TR><TR><TD height="20">Sean</TD><TD>UK</TD></TR><TR><TD height="20">Sean</TD><TD>Nizeria</TD></TR><TR><TD height="20">White</TD><TD>Singapore</TD></TR><TR><TD height="20">White</TD><TD>Malaysia</TD></TR><TR><TD height="20">White</TD><TD>Thailand</TD></TR></TBODY></TABLE><P>Thanks in Advance...</P></BODY></HTML> Sun, 21 Jun 2015 09:50:33 GMT 2015-06-21T09:50:33Z Modeling https://community.qlik.com/t5/QlikView/Modeling/m-p/867656#M998505 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I am new to QV. </P><P>Hope anybody could help me please !!</P><P></P><P>I have a requirement to build the model and Dashboards</P><P>Requirements : in metrics/KPI's</P><P>1.Count of Unique Stores by User </P><P>2.Count of Unique Users</P><P>3.Total stores visited(actual)</P><P>4.Total stores should be visited</P><P>5.Pending Stores remained to visit</P><P></P><P>Below are the sample tables</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="352"><TBODY><TR><TD colspan="2" height="20" width="220">Main Transaction table</TD></TR><TR><TD class="xl66" height="20">ID</TD><TD class="xl66">User</TD><TD class="xl66">Date</TD><TD class="xl66">Product</TD></TR><TR><TD height="20">abc111</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc111</TD></TR><TR><TD height="20">abc111</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc112</TD></TR><TR><TD height="20">abc112</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc113</TD></TR><TR><TD height="20">abc112</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc114</TD></TR><TR><TD height="20">abc113</TD><TD>Lucy</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc115</TD></TR><TR><TD height="20">abd114</TD><TD>Sean</TD><TD align="right" class="xl65">1/06/2015</TD><TD>Pdc116</TD></TR><TR><TD height="20">abd114</TD><TD>Sean</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc117</TD></TR><TR><TD height="20">abd115</TD><TD>Sean</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc118</TD></TR><TR><TD height="20">abd116</TD><TD>White</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc119</TD></TR><TR><TD height="20">abc116</TD><TD>White</TD><TD align="right" class="xl65">2/06/2015</TD><TD>Pdc120</TD></TR><TR><TD height="20">abc117</TD><TD>White</TD><TD align="right" class="xl65">4/06/2015</TD><TD>Pdc121</TD></TR><TR><TD height="20">abc117</TD><TD>White</TD><TD align="right" class="xl65">4/06/2015</TD><TD>Pdc122</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD colspan="2" height="20" width="175">Detail(Unique)</TD></TR><TR><TD class="xl65" height="20">ID</TD><TD class="xl65">Store</TD></TR><TR><TD height="20">abc111</TD><TD>Australia</TD></TR><TR><TD height="20">abc112</TD><TD>America</TD></TR><TR><TD height="20">abd114</TD><TD>Dubai</TD></TR><TR><TD height="20">abc116</TD><TD>-</TD></TR><TR><TD height="20">abc117</TD><TD>-</TD></TR><TR><TD height="20">abc118</TD><TD>Thailand</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 169px;"><TBODY><TR><TD colspan="2" height="20" width="169">Lookup(Stores allocated to each user)</TD></TR><TR><TD class="xl65" height="20">User</TD><TD class="xl65">Stores</TD></TR><TR><TD height="20">Lucy</TD><TD>Australia</TD></TR><TR><TD height="20">Lucy</TD><TD>America</TD></TR><TR><TD height="20">Lucy</TD><TD>Austria</TD></TR><TR><TD height="20">Sean</TD><TD>Dubai</TD></TR><TR><TD height="20">Sean</TD><TD>UK</TD></TR><TR><TD height="20">Sean</TD><TD>Nizeria</TD></TR><TR><TD height="20">White</TD><TD>Singapore</TD></TR><TR><TD height="20">White</TD><TD>Malaysia</TD></TR><TR><TD height="20">White</TD><TD>Thailand</TD></TR></TBODY></TABLE><P>Thanks in Advance...</P></BODY></HTML> Sun, 21 Jun 2015 09:50:33 GMT https://community.qlik.com/t5/QlikView/Modeling/m-p/867656#M998505 2015-06-21T09:50:33Z