topic Re: loading new data into qvd in QlikView https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846062#M1007654 <HTML><HEAD></HEAD><BODY><P>I do agree with Sana</P></BODY></HTML> Tue, 12 May 2015 19:16:16 GMT 2015-05-12T19:16:16Z loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846055#M1007647 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>i have a qvd with following info</P><P></P><P><STRONG>CustomerGroup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CustomerNo&nbsp;&nbsp;&nbsp;&nbsp; CustomerName</STRONG></P><P><STRONG>&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e000152&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web Sales</STRONG></P><P><STRONG>&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; u153562&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Web Sales</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c004568&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Same day sales</STRONG></P><P><STRONG>&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; m256890&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Same day sales</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d658000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ebay customer</STRONG></P><P><STRONG>&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a100052&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>Ebay customer</STRONG></SPAN></P><P></P><P></P><P>Now i need to add the following line into the qvd (like sql bucketing, temporary table)</P><P style="font-size: 13.3333330154419px;">CustomerGroup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CustomerName</P><P style="font-size: 13.3333330154419px;">&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; All Customer</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">the condition here is, if i select customergroup as 90, then it has to show all the details (bolded) under the name All customername.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">how can i do this in load script. please help me in this regard.</P></BODY></HTML> Tue, 12 May 2015 16:10:18 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846055#M1007647 2015-05-12T16:10:18Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846056#M1007648 <HTML><HEAD></HEAD><BODY><P>what would happen to the Customer no column. i am confused to what the output would be like.<SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">what are yo trying to </SPAN>achieve<SPAN style="font-size: 10pt; line-height: 1.5em;">. is it just a layout thing</SPAN></P></BODY></HTML> Tue, 12 May 2015 16:25:35 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846056#M1007648 2015-05-12T16:25:35Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846057#M1007649 <HTML><HEAD></HEAD><BODY><P>the customergroup 90 means, it should have all the customerNo &amp; customerNames. thats why the name All customer.</P><P>How can i do this.</P><P>looking forward to your reply</P></BODY></HTML> Tue, 12 May 2015 16:29:59 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846057#M1007649 2015-05-12T16:29:59Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846058#M1007650 <HTML><HEAD></HEAD><BODY><P>You do not need a specific group to do this. Selecting nothing in QlikView is the same as selecting all values.</P><P>So leave the customer group/names with no selections and all customers are included in your expressions.</P></BODY></HTML> Tue, 12 May 2015 16:34:52 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846058#M1007650 Colin-Albert 2015-05-12T16:34:52Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846059#M1007651 <HTML><HEAD></HEAD><BODY><P>No.</P><P>I need to get the sales data for all customers only when i select customer group 90</P></BODY></HTML> Tue, 12 May 2015 16:57:06 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846059#M1007651 2015-05-12T16:57:06Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846060#M1007652 <HTML><HEAD></HEAD><BODY><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="color: #000000; font-size: 12pt;">try script below:<BR /></SPAN></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="color: #000000; font-size: 12pt;"><BR /></SPAN></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="color: #000000;"><SPAN style="font-size: 12pt;">Customer_Table:</SPAN><BR /> </SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0433ff;"><STRONG>LOAD</STRONG></SPAN><SPAN style="color: #000000;"> </SPAN></SPAN><BR /><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp; CustomerGroup, CustomerNo, CustomerName</SPAN></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="font-size: 12pt;">from …..qvd;<SPAN style="color: #000000;"><BR /> </SPAN></SPAN></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="color: #0433ff; font-size: 12pt;"><BR /></SPAN></P><P style="font-size: 9px; font-family: 'Courier New'; color: #941100;"><SPAN style="font-size: 12pt;"><SPAN style="color: #0433ff;">Concatenate</SPAN><SPAN style="color: #000000;"><BR /> </SPAN><SPAN style="color: #0433ff;"><STRONG>Load</STRONG></SPAN><SPAN style="color: #000000;"> </SPAN>CustomerNo<SPAN style="color: #000000;">,<BR /> '90' </SPAN><SPAN style="color: #0433ff;">as</SPAN><SPAN style="color: #000000;"> </SPAN>CustomerGroup<SPAN style="color: #000000;">,<BR /> 'All Customer' </SPAN><SPAN style="color: #0433ff;">as</SPAN><SPAN style="color: #000000;"> </SPAN>CustomerName<SPAN style="color: #000000;"><BR /> </SPAN><SPAN style="color: #0433ff;">Resident</SPAN><SPAN style="color: #000000;"> <SPAN style="color: #000000; font-family: 'Courier New';">Customer_Table</SPAN>;<BR /> <BR />&nbsp; </SPAN></SPAN></P><P><SPAN style="color: #000000;">hope this works.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">regards</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">sana<BR /></SPAN></P></BODY></HTML> Tue, 12 May 2015 17:32:36 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846060#M1007652 2015-05-12T17:32:36Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846061#M1007653 <HTML><HEAD></HEAD><BODY><P><EM><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86329_1.png" style="height: 146px; width: 620px;" /><BR /></EM></P><P><EM><BR /></EM></P><P><EM>a:</EM></P><P><EM>load * inline [</EM></P><P><EM>CustomerGroup ,&nbsp;&nbsp;&nbsp;&nbsp; CustomerNo,&nbsp;&nbsp;&nbsp;&nbsp; CustomerName</EM></P><P><EM>&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e000152 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web Sales</EM></P><P><EM>&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; u153562&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web Sales</EM></P><P><EM>&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c004568&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Same day sales</EM></P><P><EM>&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; m256890&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Same day sales</EM></P><P><EM>&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d658000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ebay customer</EM></P><P><EM>&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a100052&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; Ebay customer</EM></P><P><EM>&nbsp; ];</EM></P><P><EM>&nbsp; </EM></P><P><EM> b: </EM></P><P><EM> load&nbsp; distinct CustomerGroup as CustomerGroup2, CustomerName as CustomerName2, CustomerGroup Resident a;</EM></P><P><EM> Concatenate(b) load distinct 90 as CustomerGroup2, 'All Customer' as CustomerName2, CustomerGroup Resident a;</EM></P></BODY></HTML> Tue, 12 May 2015 18:40:35 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846061#M1007653 maxgro 2015-05-12T18:40:35Z Re: loading new data into qvd https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846062#M1007654 <HTML><HEAD></HEAD><BODY><P>I do agree with Sana</P></BODY></HTML> Tue, 12 May 2015 19:16:16 GMT https://community.qlik.com/t5/QlikView/loading-new-data-into-qvd/m-p/846062#M1007654 2015-05-12T19:16:16Z