Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
DS395
Contributor III
Contributor III

KPI - Sum of a master key figure (=SUM([Mastervalue])) - Error

Hello forum members,

I am facing a problem which I can't get solved. I have created a table with values from a dimension and master key values I created. As far as everything is no problem (see screenshot). I would like to create a KPI from the sum of a master key value. However, it then tells me that no double summation may take place. Since in the master key value is already summed and I enter the following in the KPI: SUM([master key value]) Is the problem in the master code or am I already going about it the wrong way?

example.png

friendly greetings

dash

Labels (1)
2 Replies
Chanty4u
MVP
MVP

Try this 

SUM(aggr(SUM(MasterKeyField), DimensionField))

 

DS395
Contributor III
Contributor III
Author

Hello,

unfortunately this did not help me.