Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soloeeeoff
Contributor III
Contributor III

How to do aggregation in Chart - table

  1. I want to represent data in the (Data_1 --> Sheet 1 ) as (Data_1 --> Sheet2).
  2. 2.png1.PNG
4 Replies
Anil_Babu_Samineni

Is this you are expecting?

I've update new one, My muistake

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Another option would be to create three new expressions like this:

=Sum(Mark1)/Sum(TOTAL Mark1)

=Sum(Mark2)/Sum(TOTAL Mark2)

=Sum(Mark3)/Sum(TOTAL Mark3)


Capture.PNG

soloeeeoff
Contributor III
Contributor III
Author

Dear Anil,

Can you please tell me what is the difference between

1. Sum(Mark1)

2. Sum( All Mark1)

3. Sum(Total Mark1)

4. Sum(Distinct Mark1)

5. Sum(${Mark1} Mark1)

Anil_Babu_Samineni

I recommend you start your self by hand then you will get more clarification. please find attachment then observe, Which is make sense...

With %

Capture.PNG

Without %

Capture1.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)