topic Auto generate data based on existing DB + Factors in QlikView

topic Auto generate data based on existing DB + Factors in QlikView https://community.qlik.com/t5/QlikView/Auto-generate-data-based-on-existing-DB-Factors/m-p/50608#M606303 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi all,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I'm wondering how could I autogenerate new data as described in the following script scenario?</SPAN></P><P style="font-size: 13.3333px;">I would like to auto-generate new records based on averages from the existing data by categories as described below</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG>//ORIGINAL ITEMS DATA <BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG>1st table:</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Load</STRONG></P><P style="font-size: 13.3333px;">Item</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Item description]</SPAN></P><P style="font-size: 13.3333px;">Category</P><P style="font-size: 13.3333px;">Supplier</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Quantity units in a case]</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Quantity cases in a pallet]</SPAN></P><P style="font-size: 13.3333px;">[Quantity units in pallet]</P><P style="font-size: 13.3333px;">[Unit Height]</P><P style="font-size: 13.3333px;">[Unit Width]</P><P style="font-size: 13.3333px;">[Unit Length]</P><P style="font-size: 13.3333px;">[Unit Weight]</P><P style="font-size: 13.3333px;">[Unit vol]</P><P style="font-size: 13.3333px;">From <STRONG style="font-size: 13.3333px;">table1.qvd;</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">//FACTORS FOR DATA GENERATION BASED ON INPUTFIELDS + MACRO FOR <STRONG style="font-size: 13.3333px;">FACTORS </STRONG>EXPORTING </STRONG></P><P style="font-size: 13.3333px;"><STRONG>2nd table:</STRONG></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG>Load</STRONG><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Category</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Count(Distinct <SPAN style="font-size: 13.3333px;">Item) as [<SPAN style="font-size: 13.3333px;">Quantity </SPAN>of items]</SPAN><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Growing factor]</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">from <STRONG style="font-size: 13.3333px;">table2.qvd;</STRONG><BR /></SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">//Category's Avg values for data generation</P><P style="font-size: 13.3333px;"><STRONG>3rd table:</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Load</STRONG></P><P style="font-size: 13.3333px;">Category</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">avg([Quantity units in a case])</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">avg([Quantity cases in a pallet])</SPAN></P><P style="font-size: 13.3333px;">avg([Quantity units in pallet])</P><P style="font-size: 13.3333px;">avg([Unit Height])</P><P style="font-size: 13.3333px;">avg([Unit Width])</P><P style="font-size: 13.3333px;">avg([Unit Length])</P><P style="font-size: 13.3333px;">avg([Unit Weight])</P><P style="font-size: 13.3333px;">avg([Unit vol])</P><P style="font-size: 13.3333px;"><STRONG>Resident</STRONG> <STRONG style="font-size: 13.3333px;">table1.qvd</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">group by <SPAN style="font-size: 13.3333px;">Category</SPAN>;</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Concatenate(<STRONG style="font-size: 13.3333px;">1st table)</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">4th table:</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Load </STRONG></P><P style="font-size: 13.3333px;">Random (Item)<STRONG style="font-size: 13.3333px;"> // Should be autogenerate</STRONG></P><P style="font-size: 13.3333px;">Random (Item description)<STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"> <STRONG style="font-size: 13.3333px;">// Should be autogenerate </STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;">Category<STRONG style="font-size: 13.3333px;">// Based on category list from <STRONG style="font-size: 13.3333px;">3rd</STRONG> table</STRONG></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Random(Supplier)</SPAN><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"> <STRONG style="font-size: 13.3333px;">// Should be autogenerate based on exists data(Randomly)</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">auto generate ceil(</SPAN><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[</SPAN><SPAN style="font-size: 13.3333px;">Quantity </SPAN><SPAN style="font-size: 13.3333px;">of items]*<SPAN style="font-size: 13.3333px;">[Growing factor]) - <SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[</SPAN><SPAN style="font-size: 13.3333px;">Quantity </SPAN></SPAN></SPAN></SPAN></SPAN><SPAN style="font-size: 13.3333px;">of items];</SPAN></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style=": ; font-size: 13.3333px;">// Should autogenerate the number of required records by category</STRONG></STRONG></SPAN><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">left join </STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Load * </STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Resident</STRONG><SPAN style="font-size: 13.3333px;">  <STRONG style="font-size: 13.3333px;">3rd table;</STRONG></SPAN></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Thank you</STRONG></P></BODY></HTML> Mon, 04 Jun 2018 12:56:03 GMT seWork 2018-06-04T12:56:03Z Auto generate data based on existing DB + Factors https://community.qlik.com/t5/QlikView/Auto-generate-data-based-on-existing-DB-Factors/m-p/50608#M606303 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi all,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I'm wondering how could I autogenerate new data as described in the following script scenario?</SPAN></P><P style="font-size: 13.3333px;">I would like to auto-generate new records based on averages from the existing data by categories as described below</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG>//ORIGINAL ITEMS DATA <BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG>1st table:</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Load</STRONG></P><P style="font-size: 13.3333px;">Item</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Item description]</SPAN></P><P style="font-size: 13.3333px;">Category</P><P style="font-size: 13.3333px;">Supplier</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Quantity units in a case]</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Quantity cases in a pallet]</SPAN></P><P style="font-size: 13.3333px;">[Quantity units in pallet]</P><P style="font-size: 13.3333px;">[Unit Height]</P><P style="font-size: 13.3333px;">[Unit Width]</P><P style="font-size: 13.3333px;">[Unit Length]</P><P style="font-size: 13.3333px;">[Unit Weight]</P><P style="font-size: 13.3333px;">[Unit vol]</P><P style="font-size: 13.3333px;">From <STRONG style="font-size: 13.3333px;">table1.qvd;</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">//FACTORS FOR DATA GENERATION BASED ON INPUTFIELDS + MACRO FOR <STRONG style="font-size: 13.3333px;">FACTORS </STRONG>EXPORTING </STRONG></P><P style="font-size: 13.3333px;"><STRONG>2nd table:</STRONG></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG>Load</STRONG><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Category</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Count(Distinct <SPAN style="font-size: 13.3333px;">Item) as [<SPAN style="font-size: 13.3333px;">Quantity </SPAN>of items]</SPAN><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[Growing factor]</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">from <STRONG style="font-size: 13.3333px;">table2.qvd;</STRONG><BR /></SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">//Category's Avg values for data generation</P><P style="font-size: 13.3333px;"><STRONG>3rd table:</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Load</STRONG></P><P style="font-size: 13.3333px;">Category</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">avg([Quantity units in a case])</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">avg([Quantity cases in a pallet])</SPAN></P><P style="font-size: 13.3333px;">avg([Quantity units in pallet])</P><P style="font-size: 13.3333px;">avg([Unit Height])</P><P style="font-size: 13.3333px;">avg([Unit Width])</P><P style="font-size: 13.3333px;">avg([Unit Length])</P><P style="font-size: 13.3333px;">avg([Unit Weight])</P><P style="font-size: 13.3333px;">avg([Unit vol])</P><P style="font-size: 13.3333px;"><STRONG>Resident</STRONG> <STRONG style="font-size: 13.3333px;">table1.qvd</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">group by <SPAN style="font-size: 13.3333px;">Category</SPAN>;</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Concatenate(<STRONG style="font-size: 13.3333px;">1st table)</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">4th table:</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Load </STRONG></P><P style="font-size: 13.3333px;">Random (Item)<STRONG style="font-size: 13.3333px;"> // Should be autogenerate</STRONG></P><P style="font-size: 13.3333px;">Random (Item description)<STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"> <STRONG style="font-size: 13.3333px;">// Should be autogenerate </STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;">Category<STRONG style="font-size: 13.3333px;">// Based on category list from <STRONG style="font-size: 13.3333px;">3rd</STRONG> table</STRONG></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Random(Supplier)</SPAN><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"> <STRONG style="font-size: 13.3333px;">// Should be autogenerate based on exists data(Randomly)</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">auto generate ceil(</SPAN><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[</SPAN><SPAN style="font-size: 13.3333px;">Quantity </SPAN><SPAN style="font-size: 13.3333px;">of items]*<SPAN style="font-size: 13.3333px;">[Growing factor]) - <SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">[</SPAN><SPAN style="font-size: 13.3333px;">Quantity </SPAN></SPAN></SPAN></SPAN></SPAN><SPAN style="font-size: 13.3333px;">of items];</SPAN></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style=": ; font-size: 13.3333px;">// Should autogenerate the number of required records by category</STRONG></STRONG></SPAN><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">left join </STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Load * </STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Resident</STRONG><SPAN style="font-size: 13.3333px;">  <STRONG style="font-size: 13.3333px;">3rd table;</STRONG></SPAN></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Thank you</STRONG></P></BODY></HTML> Mon, 04 Jun 2018 12:56:03 GMT https://community.qlik.com/t5/QlikView/Auto-generate-data-based-on-existing-DB-Factors/m-p/50608#M606303 seWork 2018-06-04T12:56:03Z