topic Re: Set Analysis when measure is dynamic in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-when-measure-is-dynamic/m-p/514878#M192303 <HTML><HEAD></HEAD><BODY><P>Also I have taken created column in variable X so how to use X over here.</P><P>Say V1 column contain Total sum and total count and which i have assigned to X and i want to use X as shown above,</P><P>It is giving me expression error.</P><P></P><P>Regards,</P><P>Gaurav</P></BODY></HTML> Mon, 02 Dec 2013 11:35:03 GMT 2013-12-02T11:35:03Z Set Analysis when measure is dynamic https://community.qlik.com/t5/QlikView/Set-Analysis-when-measure-is-dynamic/m-p/514877#M192302 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have columns total count,Total sum as columns in data base.</P><P>I want set analysis such that</P><P>Sum({&lt;&gt;}X)</P><P>Where X will be Total sum or total count.</P><P>How to achieve this.I will take Total sum and total count in columns that is not problem, my problem is syntax of X</P><P></P><P>Thanks</P></BODY></HTML> Mon, 02 Dec 2013 11:28:24 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-when-measure-is-dynamic/m-p/514877#M192302 2013-12-02T11:28:24Z Re: Set Analysis when measure is dynamic https://community.qlik.com/t5/QlikView/Set-Analysis-when-measure-is-dynamic/m-p/514878#M192303 <HTML><HEAD></HEAD><BODY><P>Also I have taken created column in variable X so how to use X over here.</P><P>Say V1 column contain Total sum and total count and which i have assigned to X and i want to use X as shown above,</P><P>It is giving me expression error.</P><P></P><P>Regards,</P><P>Gaurav</P></BODY></HTML> Mon, 02 Dec 2013 11:35:03 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-when-measure-is-dynamic/m-p/514878#M192303 2013-12-02T11:35:03Z