Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
DS395
Contributor II
Contributor II

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 II
Contributor II
Author

Hello,

unfortunately this did not help me.