topic Re: output a variable instead of a number inside a formula in QlikView

output a variable instead of a number inside a formula

Fri, 07 Nov 2014 22:01:14 GMT

Hi, I am looking to make a calculation spit out a variable instead of a number inside a summation formula - for example,

sum(

if(

isnull(ID), Revenue, NullRevenue, Revenue))

Ideally the output should be sum(Revenue) or sum(NullRevenue), but since if(isnull(ID), Revenue, NullRevenue, Revenue) spits out a number it ends up calculating sum(some numerical value). Any idea would be appreciated, thanks!

Re: output a variable instead of a number inside a formula

danieloberbilli — Fri, 07 Nov 2014 22:12:05 GMT

you can write a variable like this in the backend

LET vResult = '=sum(if(isnull(ID), Revenue, NullRevenue))';

Re: output a variable instead of a number inside a formula

MarcoWedel — Fri, 07 Nov 2014 22:44:16 GMT

if you like to get the strings 'sum(Revenue)' or 'sum(NullRevenue)' then you could try like:

='Sum('&If(IsNull(ID), 'NullRevenue', 'Revenue')&')'

hope this helps

regards

Marco