topic Re: dynamically generating data for some columns in report in QlikView https://community.qlik.com/t5/QlikView/dynamically-generating-data-for-some-columns-in-report/m-p/743893#M1031517 <HTML><HEAD></HEAD><BODY><P>Force the user to make selections first so that the expressions are not calculated of 5 lakh records, but only the records that meet the users selections.</P></BODY></HTML> Wed, 04 Feb 2015 18:27:58 GMT Gysbert_Wassenaar 2015-02-04T18:27:58Z dynamically generating data for some columns in report https://community.qlik.com/t5/QlikView/dynamically-generating-data-for-some-columns-in-report/m-p/743892#M1031516 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> I have a qvd with more than 5 lakh records.</SPAN></P><P> But when running the report user will be selecting one of the record.</P><P> I need to run a complex logic based on the user input or i have to run for all the records in the base qvd.</P><P> Running the logic for all the records in the base qvd takes many hours(which is not acceptable).</P><P> Can somebody tell us whether we can derive the complex logic for only the selected input from the user.</P><P></P><P style="font-size: 13.3333330154419px;">E.x Report </P><P style="font-size: 13.3333330154419px;">Input : Input 1</P><P><SPAN style="font-size: 13.3333330154419px;">Output : same as the table above. Input 1 and Output 1 can be derived for all the 5lakh records. but for the Output 2 it needs the complex logic.</SPAN></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 198px; height: 62px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Input 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Output 1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Output 2</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">11</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">32</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P><SPAN style="font-size: 13.3333330154419px;">Input 1 and Output 1 can be generated into single qvd and this can be added to the input filter. Once it is selected the Output 2 column needs to be derived based on the input from the user using the complex logic.</SPAN></P><P>is it possible to generate partial output from qvd and partial output from dynamic script execution with user input?</P></BODY></HTML> Wed, 04 Feb 2015 14:47:39 GMT https://community.qlik.com/t5/QlikView/dynamically-generating-data-for-some-columns-in-report/m-p/743892#M1031516 2015-02-04T14:47:39Z Re: dynamically generating data for some columns in report https://community.qlik.com/t5/QlikView/dynamically-generating-data-for-some-columns-in-report/m-p/743893#M1031517 <HTML><HEAD></HEAD><BODY><P>Force the user to make selections first so that the expressions are not calculated of 5 lakh records, but only the records that meet the users selections.</P></BODY></HTML> Wed, 04 Feb 2015 18:27:58 GMT https://community.qlik.com/t5/QlikView/dynamically-generating-data-for-some-columns-in-report/m-p/743893#M1031517 Gysbert_Wassenaar 2015-02-04T18:27:58Z