topic Re: Column(1)+Column(2)+... Expression for Dynamically enabled columns in QlikView

Column(1)+Column(2)+... Expression for Dynamically enabled columns

diwakarnahata — Fri, 07 Nov 2014 09:54:57 GMT

Hi,

I have a Bar Chart where I am trying to create an expression which is the some of all other previous Expressions (10 expr in my case), like Column(1)+Column(2)+.....Column(10). But this gives me null as result since all these 10 columns are conditionally enabled, and at any point of time any no. of columns can get enabled. How can I handle this situation?

I tried with column labels as well but the result is the same.

Regards,

Diwakar

Re: Column(1)+Column(2)+... Expression for Dynamically enabled columns

sushil353 — Fri, 07 Nov 2014 10:01:29 GMT

Hi,

Try like =Alt(column(1),0)+Alt(column(2),0)+....................alt(column(10),0)

HTH

sushil

Re: Column(1)+Column(2)+... Expression for Dynamically enabled columns

amit_saini — Fri, 07 Nov 2014 10:03:15 GMT

Diwakar,

Are you doing this way , see attachment.

Thanks,
AS

Re: Re: Column(1)+Column(2)+... Expression for Dynamically enabled columns

diwakarnahata — Fri, 07 Nov 2014 10:42:21 GMT

Hi Sushil,

It is working partially but it is giving twice the expected count. Probably because it is summing up itself. And, dividing the outcome by 2 is also not helping.

Moreover, the whole idea to create this expression was to use it into the denominator of all other expressions to calculate % contribution of each expression of the whole.

So, going by the same attached example, instead of showing the values, I wanted to show % contribution of each Jack,John,Mark etc. for each column A,B,C... and these columns will be enabled dynamically.

Let me know if you need any more details.

Regards,

Diwakar