Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sutheeshsham
Contributor II
Contributor II

how to divide two valus in same colimn

Hi All,

i'm new to Qlik sense

i have a doubt in qlik sense,

now i have created a pivot table , that table has two rows, 

for eg:

description          student1    student2   student3   student4  .....

english                     95                        53              45                88

maths                       58                        58             67                 84

 

total                         english/maths    eng/math   eng/math eng/math  ..........

 

so how to calculate the total ?

if anybody knows please help me out ASAP

Labels (2)
1 Solution

Accepted Solutions
sutheeshsham
Contributor II
Contributor II
Author

yes @sidhiq91  that's fine i can able to do that but when i gonna calculate other aggregation how to do that ?

see this part is sum up the values only right. but i want to divide and subract the values

 

so if know that please help me out 

View solution in original post

3 Replies
Or
MVP
MVP

Generally speaking, totals are enabled per dimension:

Or_0-1659446180223.png

 

It's not very clear what exact totals you're looking for, but I'm sure you can find your way through trial and error to enable the right one. Perhaps what you're looking for is a base expression of:

Avg(Grade) / Count(distinct Course)

sidhiq91
Specialist II
Specialist II

@sutheeshsham  I was about to reply what @Or  has already replied. You need to Enable the show total button in the first Dimension as shown below:

sidhiq91_0-1659446630780.png

 

sidhiq91_1-1659446673933.png

 

sutheeshsham
Contributor II
Contributor II
Author

yes @sidhiq91  that's fine i can able to do that but when i gonna calculate other aggregation how to do that ?

see this part is sum up the values only right. but i want to divide and subract the values

 

so if know that please help me out