Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
ionuttatu
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
sasiparupudi1
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..)

)