Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Partial sums = '-' in pivot table (Sorry i posted it in QLIKSENSE instead of QLIKVIEW)

Hello

I am encountering an issue when creating a report.

 

I have 2 tables - as in the below example

A. sales

YEAR_MONTH / AREA_SALES_MANAGER / PAYER / SALES VALUE

201906 / Daniel X / LIDL / 1000

201906 / Daniel X / ALDI / 1500

.....

 

B. calendar

YEAR_MONTH / DAYS_PASSED / NUMBER_OF_DAYS

201906 / 24 / 25

 

My pivot table should show a calculation like the image

 

The formula for the actual trend is 

 

=[SALES VALUE]/(AVG(DAYS_PASSED))*(Avg(NUMBER_OF_DAYS))

 

Do you have any ideas?

 

1 Reply
Highlighted
Honored Contributor III

Re: Partial sums = '-' in pivot table (Sorry i posted it in QLIKSENSE instead of QLIKVIEW)

May be try

Avg(

Aggr(

 Sum([SALES VALUE])/(AVG(DAYS_PASSED))*(Avg(NUMBER_OF_DAYS))

,Dim1,Dim2..)

)