Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

%

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))

Capture.PNG

Any help please.

6 Replies
swuehl
MVP
MVP

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().

ogautier62
Specialist II
Specialist II

Hi,

try too using names of your column,

column(N°) not so good

regards

master_student
Creator III
Creator III
Author

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

master_student
Creator III
Creator III
Author

my columns are expressions

ogautier62
Specialist II
Specialist II

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

ogautier62
Specialist II
Specialist II

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 !