topic Re: Use dimension value as fieldname in expression in QlikView https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872178#M304872 <HTML><HEAD></HEAD><BODY><P>Hi Jon,</P><P>try using cross table in script and rank function in expression</P><P></P><P>Attached your app with this approach (I added some extra factors to check the app)</P><P></P><P>Best regards</P></BODY></HTML> Tue, 21 Apr 2015 17:22:46 GMT anlonghi2 2015-04-21T17:22:46Z Use dimension value as fieldname in expression https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872176#M304870 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have a dataset that is Customer and 80+ factors from 0-1</P><P></P><P>I need to rank the top ten factors.</P><P></P><P>To do this, i have loaded the factor fieldnames into a data island called dimensions.</P><P></P><P>My theory is to create a chart and set dimension as dimension, and input the dimension value into the expression, so i get avg([value of dimension]).</P><P></P><P>Is this doable?</P><P></P><P>I attached an example.</P></BODY></HTML> Tue, 21 Apr 2015 08:33:48 GMT https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872176#M304870 2015-04-21T08:33:48Z Re: Use dimension value as fieldname in expression https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872177#M304871 <HTML><HEAD></HEAD><BODY><P>Check this app</P></BODY></HTML> Tue, 21 Apr 2015 16:30:36 GMT https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872177#M304871 anbu1984 2015-04-21T16:30:36Z Re: Use dimension value as fieldname in expression https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872178#M304872 <HTML><HEAD></HEAD><BODY><P>Hi Jon,</P><P>try using cross table in script and rank function in expression</P><P></P><P>Attached your app with this approach (I added some extra factors to check the app)</P><P></P><P>Best regards</P></BODY></HTML> Tue, 21 Apr 2015 17:22:46 GMT https://community.qlik.com/t5/QlikView/Use-dimension-value-as-fieldname-in-expression/m-p/872178#M304872 anlonghi2 2015-04-21T17:22:46Z