Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahmooddba
New 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
MVP
MVP

Re: Row Total in Pivot Table of Qlik Sense

Try this

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

4 Replies
MVP
MVP

Re: Row Total in Pivot Table of Qlik Sense

Try this

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

devarasu07
Honored Contributor 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

mahmooddba
New Contributor II

Re: Row Total in Pivot Table of Qlik Sense

Thank you very much!

mahmooddba
New 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.