Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
MVP & Luminary
MVP & Luminary

Try this,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Creator III
Creator III

Hi

Try this

Sum(Marks)/Sum(TOTAL Marks)


Regards

An Pham