Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ionuttatu
Contributor II
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?

 

Labels (3)
1 Reply
sasiparupudi1
Master III
Master III

May be try

Avg(

Aggr(

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

,Dim1,Dim2..)

)