Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have to tables. in the first one there each line has a unique ID
In the second one for each ID I can have several attributes
if I use this formula: count(distinct(if(Attribute='MID',ID))) result is 4
but if I use formula sum(distinct(if(Attribute='MID',Sales))) result is 60 (but I would like to find 70)
and if I use formula sum(if(Attribute='MID',Sales)) result is 100 (because I have two lines with MID for ID=D)
what would be the syntax in order to only sum once each line in my first table ?
Thanks for your help
Go to Solution.
Hi, I found the solution using
Like this -