topic Value List - Performance in QlikView https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913961#M317031 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to create one straight table to show certain KPIs with comparison. To represent KPI's as dimension, I am using ValueList. </P><P></P><P>Need experts suggestion, is it good to use or is there any other method to showcase ?</P></BODY></HTML> Fri, 24 Jul 2015 11:32:05 GMT manojkulkarni 2015-07-24T11:32:05Z Value List - Performance https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913961#M317031 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to create one straight table to show certain KPIs with comparison. To represent KPI's as dimension, I am using ValueList. </P><P></P><P>Need experts suggestion, is it good to use or is there any other method to showcase ?</P></BODY></HTML> Fri, 24 Jul 2015 11:32:05 GMT https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913961#M317031 manojkulkarni 2015-07-24T11:32:05Z Re: Value List - Performance https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913962#M317032 <HTML><HEAD></HEAD><BODY><P>There are ways to perform the ValueList functionality using an Inline Island Table, but not sure if there are any performance benefits there. I know with ValueList you are <STRONG>UNABLE</STRONG> to make a selection, but with inline you would be <STRONG>ABLE </STRONG>to make a selection.</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 24 Jul 2015 11:41:06 GMT https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913962#M317032 sunny_talwar 2015-07-24T11:41:06Z Re: Value List - Performance https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913963#M317033 <HTML><HEAD></HEAD><BODY><P>If you use ValueList as Calculated Dimension or as an Inline Iceland table there would be no difference in performance.</P><P>Inline Load is only to avoid duplicate written statement of ValueList using nested IFs.</P><P></P><P>Valuelist with many values and data having millions rows will give you poor performance but If there is no alternative for showing KPIs except ValueList function, one can take risk using it...</P><P></P><P>OfCourse : as suggested by Sunny... Inline load will give you advantage of KPI selection.</P></BODY></HTML> Fri, 24 Jul 2015 11:45:42 GMT https://community.qlik.com/t5/QlikView/Value-List-Performance/m-p/913963#M317033 MK_QSL 2015-07-24T11:45:42Z