Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor II

How to get % for the following

SubjectJan-2017Feb-2017
Maths-156%40%
Maths-244%60%

Here, I have two subjects maths-1 and maths-2, both for 100 marks each. But I need to a calculation like this, maths1/(maths1+maths2)[Jan-2017], I tried using the following expression. But I show result as 100% both, I want to get sum of maths1 and maths2 to be 100%

= Sum(Marks)

/ ((Sum({<Subject= {'Maths-1}>}

          Marks)

+ (Sum({<Subject= {'Maths-2'}>}

         Marks)

2 Replies

Re: How to get % for the following

Try this,

Sum (Marks) / Sum(Total<Month> Marks)

Regards,

Kaushik Solanki

kenphamvn
Contributor III

Re: How to get % for the following

Hi

Try this

Sum(Marks)/Sum(TOTAL Marks)


Regards

An Pham

Community Browser