topic Data loading (week's days one by one) in QlikView https://community.qlik.com/t5/QlikView/Data-loading-week-s-days-one-by-one/m-p/12345#M2017 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've got the data in the following format:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level</STRONG></SPAN><STRONG style="color: #ffffff;"> 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Mon</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Tue</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Wen</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Thu</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Fri</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sat</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sun</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Mon</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Tue</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Wen</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Thu</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Fri</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sat</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sun</TH></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;">Adam</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Store2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Adam</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Claire</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>There are just 2 weeks but I've got a full month (4 weeks which are located by the same way - one by one).</P><P></P><P>Could you tell me a good solution of how to organize the process of data loading in this way?</P><P></P><P></P><P><SPAN lang="EN-US" style="color: #595959;">With my best regards,</SPAN></P><P><SPAN lang="EN-US" style="color: #262626;">Evgeniy</SPAN></P></BODY></HTML> Tue, 10 Apr 2018 15:07:08 GMT Anonymous 2018-04-10T15:07:08Z Data loading (week's days one by one) https://community.qlik.com/t5/QlikView/Data-loading-week-s-days-one-by-one/m-p/12345#M2017 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've got the data in the following format:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Level</STRONG></SPAN><STRONG style="color: #ffffff;"> 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Mon</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Tue</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Wen</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Thu</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Fri</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sat</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sun</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Mon</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Tue</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Wen</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Thu</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Fri</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sat</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sun</TH></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;">Adam</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Store2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Adam</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Claire</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>There are just 2 weeks but I've got a full month (4 weeks which are located by the same way - one by one).</P><P></P><P>Could you tell me a good solution of how to organize the process of data loading in this way?</P><P></P><P></P><P><SPAN lang="EN-US" style="color: #595959;">With my best regards,</SPAN></P><P><SPAN lang="EN-US" style="color: #262626;">Evgeniy</SPAN></P></BODY></HTML> Tue, 10 Apr 2018 15:07:08 GMT https://community.qlik.com/t5/QlikView/Data-loading-week-s-days-one-by-one/m-p/12345#M2017 Anonymous 2018-04-10T15:07:08Z