Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Pivot table count total regardless of the row

I'm not able to show the company data, so I made up a similar senario:

A fruit store sells apple and banana. They have t1 to track the sales, t2 for linking, t3 for tracking number of visiting the store:

t1:

Type       key     Sales

Apple      1          20

Banana   2          40

t2:

Key       Date

1         07/01

2         07/02

t3:

Date     Visit

07/01     7

07/02     10

I'm creating a pivot table with row: Type, with measures: Sales and Visit. Now it looks like:

111.PNG

It's counting Visits by Type as well. But I want to show total visits at both Apple and Banana. which should be like:

222.PNG

Is it possible to do it from the layout?

Thanks for help!!!

3 Replies
ogautier62
Valued Contributor II

Re: Pivot table count total regardless of the row

Hi,

sum(total <Type> Visit) as a new mesure for visit should do it as far as type is a dimension

regards

agigliotti
Honored Contributor II

Re: Pivot table count total regardless of the row

maybe with a new measure as below:

sum( total Visits )

nsetty
Contributor II

Re: Pivot table count total regardless of the row

t1:

Load * inline [

Type,Key,Sales

Apple,1,20

Banana,2,40

];

t2:

Load * inline [

Key,Date

1,07/01

2,07/02

];

t3:

Load * inline [

Date,Visit

07/01,7

07/02,10

];

Measure: sum(Total [t1.Visit])

Community Browser