topic Macro in QlikView

topic Macro in QlikView https://community.qlik.com/t5/QlikView/Macro/m-p/624197#M229710 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need a macro which, when vDoor1 = 1, selects one random data depending on its name. I have no knowledge of VBS, and I haven't found any guides either... I could imagine it being something like this: IF(variable=1) THEN SELECT if(Rand<=0.5 AND Name=*text) THEN Field[Data] ELSE Field[Data2]</P><P></P><P>Thanks for your help in advance,</P><P>Lucas</P></BODY></HTML> Tue, 11 Mar 2014 13:23:17 GMT 2014-03-11T13:23:17Z Macro https://community.qlik.com/t5/QlikView/Macro/m-p/624197#M229710 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need a macro which, when vDoor1 = 1, selects one random data depending on its name. I have no knowledge of VBS, and I haven't found any guides either... I could imagine it being something like this: IF(variable=1) THEN SELECT if(Rand<=0.5 AND Name=*text) THEN Field[Data] ELSE Field[Data2]</P><P></P><P>Thanks for your help in advance,</P><P>Lucas</P></BODY></HTML> Tue, 11 Mar 2014 13:23:17 GMT https://community.qlik.com/t5/QlikView/Macro/m-p/624197#M229710 2014-03-11T13:23:17Z