topic Re: % in QlikView

%

master_student — Fri, 08 Jun 2018 09:16:54 GMT

Hello Guys

I hope all is well.

I need to get the % from 2 Totals : 204/ (204+2816)

heres the expression that I use : % : sum(Column(4))/ sum(Column(4)+Column(5))

Any help please.

Re: %

swuehl — Fri, 08 Jun 2018 09:29:07 GMT

Try without the aggregation:

Column(4) / (Column(4) +Column(5))

BTW, which columns in your screenshot are you referring to? Maybe you need to handle NULLs as well, e.g. using Rangesum().

Re: %

ogautier62 — Fri, 08 Jun 2018 11:36:16 GMT

Hi,

try too using names of your column,

column(N°) not so good

regards

Re: %

master_student — Fri, 08 Jun 2018 13:18:05 GMT

Hello Stefan,

I tried without the aggregation but it didn't work. I am refering to the total of Nbr de cas Hors delais 204 and the Total of Nbr de cas dans les delais 2816

Re: %

master_student — Fri, 08 Jun 2018 13:18:37 GMT

my columns are expressions

Re: %

ogautier62 — Fri, 08 Jun 2018 13:25:39 GMT

and what are your expressions ?

the error is in one of the expression, you shoudn't have '-' in 'Nbr cas hors délai' but 0

Re: %

ogautier62 — Fri, 08 Jun 2018 13:50:19 GMT

I think you use if in your expression : if(condition,1)

so in expression % you can't use name of field, but repeat the formula :

sum(if( ,1)) / (sum( ) + sum())

and in this expression : check 'total of expression' and not 'sum of rows'

without the expression difficult to say what's wrong in expression !