topic Re: Using variables in set expressions in QlikView

Using variables in set expressions

Anonymous — Fri, 20 Nov 2015 22:11:27 GMT

I have the following expression:

Sum({<Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, [PLUS FIVE],[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>} Amount)

I want to replace Sum(Amount) with a variable vSetTotalAmount

How can the above expression be changed to accommodate the variable?

Regards.

Re: Using variables in set expressions

sunny_talwar — Fri, 20 Nov 2015 23:08:29 GMT

As far as I know, this is not doable.

Re: Using variables in set expressions

Anonymous — Fri, 20 Nov 2015 23:14:20 GMT

Many thanks Sunny

Regards.

Re: Using variables in set expressions

rwunderlich — Sat, 21 Nov 2015 00:54:10 GMT

I'm not sure how you want the end to look, but you fill any parts of an expression using variables.

$(vFunction)({<Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, [PLUS FIVE],[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>} $v(FunctionField))

Re: Using variables in set expressions

Anonymous — Mon, 23 Nov 2015 09:29:23 GMT

Thanks, Rob, i will look into that as recommended.

Regards.