Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
Set analysis won't work here... but you can try this
Alternatively, you can take ACCESS and MH from your table and add it to another table in the backend so that only the distinct combination of ACCESS and MH exists and will join to your main table on ACCESS... if you do that, you will be able to just do Sum(MH)....
That will give me the Sum(MH) in the example above the answer will be 0.09 the sum of all MH aggregated by the distinct key Accesskey. What I want is 0.045 or the sum of the 2 distinct accesses 824 and 195. Perhaps the best idea would be to remove the MH column from the source and create a new Table with only the ACCESS and MH...