topic Re: dynamic pick match loading from spreadsheet in QlikView https://community.qlik.com/t5/QlikView/dynamic-pick-match-loading-from-spreadsheet/m-p/688249#M249283 <HTML><HEAD></HEAD><BODY><P>Cheated and simply built the formula in excel and loaded it that way</P></BODY></HTML> Wed, 02 Jul 2014 08:20:06 GMT adamdavi3s 2014-07-02T08:20:06Z dynamic pick match loading from spreadsheet https://community.qlik.com/t5/QlikView/dynamic-pick-match-loading-from-spreadsheet/m-p/688248#M249282 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I've read various things on this but I can't get it quite right.</P><P></P><P>We're building a KPI document for finance and rather than editing the app each time, we would like them to be able to define the kpis in a spreadsheet, along with the calculation.</P><P></P><P>I can get this part working fine using a pick/match, however I would like to dynamically build this pick/match formula so if they add any additional kpi's they are automatically added.</P><P></P><P>This is the little bit I can't quite fathom out.</P><P></P><P>I've attached a simplified version of what I am attempting.....</P><P></P><P>Kind regards</P><P></P><P>Adam</P></BODY></HTML> Tue, 01 Jul 2014 14:07:17 GMT https://community.qlik.com/t5/QlikView/dynamic-pick-match-loading-from-spreadsheet/m-p/688248#M249282 adamdavi3s 2014-07-01T14:07:17Z Re: dynamic pick match loading from spreadsheet https://community.qlik.com/t5/QlikView/dynamic-pick-match-loading-from-spreadsheet/m-p/688249#M249283 <HTML><HEAD></HEAD><BODY><P>Cheated and simply built the formula in excel and loaded it that way</P></BODY></HTML> Wed, 02 Jul 2014 08:20:06 GMT https://community.qlik.com/t5/QlikView/dynamic-pick-match-loading-from-spreadsheet/m-p/688249#M249283 adamdavi3s 2014-07-02T08:20:06Z