how to divide the two rows in same column

[sutheeshsham]

i'm new to qlik sense,

i have a doubt on qlik sense

description       A       B      C

mark1                 5        8        10

mark2                  2        6        7

total(divide)       mark1/mark2

so how to calculate the division for above the table ?

if anybody knows please let me know

[Mark_Little]

Hi @sutheeshsham 

Depends on exactly what you are wanting and where you want to do the calc. In Set Analysis one example is

SUM({<descripion={'mark1'}>}A) / SUM({<descripion={'mark2'}>}A) 

or

SUM({<descripion={'mark1'}>}A+B+C) / SUM({<descripion={'mark2'}>}A+B+C)