Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Generally speaking, totals are enabled per dimension:
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)
@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:
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