Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Row Total in Pivot Table of Qlik Sense

Hi,

I would like to get row total in pivot table as a measure based on dimension please find the attachment for reference of my requiremen

Thanks!

1 Solution

Accepted Solutions
Highlighted

Re: Row Total in Pivot Table of Qlik Sense

Try this

Sum(TOTAL <SITE, BRAND> [SALES VALUE])

View solution in original post

4 Replies
Highlighted

Re: Row Total in Pivot Table of Qlik Sense

Try this

Sum(TOTAL <SITE, BRAND> [SALES VALUE])

View solution in original post

Highlighted
Master II
Master II

Re: Row Total in Pivot Table of Qlik Sense

Hi,

You can do it in both way (fornt/back end side). which side u wanted apply that logic? if u are going to use this measure in many chart object better do it at back end else front end.

method 1:

as sunny suggestion by using the total and group by class

sum( total <SITE, BRAND> [SALES VALUE])

method 2:

Fact:

LOAD * INLINE [

    SITE, BRAND, PRODUCT SUB CATEGORY, SALES QTY, SALES VALUE

    100, PAL, CONTOURING, 24, 1943

    101, PAL, CONTOURING, 31, 2113.25

    102, PAL, CONTOURING, 22, 2026

    100, PAL, FOUNDATION, 7, 390

    101, PAL, FOUNDATION, 3, 192

    102, PAL, FOUNDATION, 5, 380

];

join (Fact)

load SITE, BRAND, sum([SALES VALUE]) as CTS Resident Fact Group by SITE, BRAND;

o/p

Capture.JPG

Highlighted
Contributor II
Contributor II

Re: Row Total in Pivot Table of Qlik Sense

Thank you very much!

Highlighted
Contributor II
Contributor II

Re: Row Total in Pivot Table of Qlik Sense

Hi,

Thanks for your time and response unfortunately i can't mark your response as correct answer as i already marked for Sunny.