topic Turn fields into variables in QlikView https://community.qlik.com/t5/QlikView/Turn-fields-into-variables/m-p/693470#M250848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement to read a QVD, then select certain fields to include, and certain fields to aggregate. </P><P></P><P>Then, on a reload with the variables selected, it should spit out a QVD with the selected fields aggregated at the chosen level.</P><P></P><P>The bit that I'm having trouble with, is generalising it such that any QVD loaded will have the requisite number of variables generated such that they can be selected. </P><P></P><P>Also, once I have the variables, is there a clean way to iterate through them? I don't want to have big nested if statements, nor lots of individual if statements.</P><P></P><P>Is such a thing possible?</P></BODY></HTML> Thu, 25 Sep 2014 09:51:43 GMT richnorris 2014-09-25T09:51:43Z Turn fields into variables https://community.qlik.com/t5/QlikView/Turn-fields-into-variables/m-p/693470#M250848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement to read a QVD, then select certain fields to include, and certain fields to aggregate. </P><P></P><P>Then, on a reload with the variables selected, it should spit out a QVD with the selected fields aggregated at the chosen level.</P><P></P><P>The bit that I'm having trouble with, is generalising it such that any QVD loaded will have the requisite number of variables generated such that they can be selected. </P><P></P><P>Also, once I have the variables, is there a clean way to iterate through them? I don't want to have big nested if statements, nor lots of individual if statements.</P><P></P><P>Is such a thing possible?</P></BODY></HTML> Thu, 25 Sep 2014 09:51:43 GMT https://community.qlik.com/t5/QlikView/Turn-fields-into-variables/m-p/693470#M250848 richnorris 2014-09-25T09:51:43Z