Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
markusblaut
Contributor III
Contributor III

Sum formula Pivot table

Hello guys,

can someone help me?

  • I have a pivot table with dimension "Product"
  • in the column I want to see the Quantity, but only from the highest selected year. (so if i select in a filter FY 2016,2017 and 2018) I only want to see the sum of the Quantity of 2018, and if I would select FY 2016 and 2017 I only want to see se sum of the Quantity of 2017, and so on...

if i insert "sum(Quantity)" i get always the sum of all selected FYs. Any idea how that could work?

Many thanks for any help!

Best Markus

Unbenannt.PNG

1 Solution

Accepted Solutions
sunny_talwar

I think you mean this

Sum({<year = {"$(=max(year))"}>} Quantity)

Sum({<FY = {"$(=max(FY))"}>} Quantity)

View solution in original post

6 Replies
agigliotti
Partner
Partner

maybe this:

sum( {< year = {"=max(year)"} >} Quantity )

I hope it helps.

markusblaut
Contributor III
Contributor III
Author

thanks for your reply Andrea! Unfortunately your suggested formular gives the same results as sum(Quantity)

agigliotti
Partner
Partner

did you try with this below ?

sum( {< FY = {"=max(FY)"} >} Quantity )


FY field should be an external filter and not a pivot dimension.

markusblaut
Contributor III
Contributor III
Author

yes i changed year to FY

sunny_talwar

I think you mean this

Sum({<year = {"$(=max(year))"}>} Quantity)

Sum({<FY = {"$(=max(FY))"}>} Quantity)

markusblaut
Contributor III
Contributor III
Author

Thank you Sunny and Andrea!!