Using Total Sum with a calculated dimension Qlik Sense
Good Afternoon! I really enjoy having this forum and looking through all of the questions throughout time.
In the picture, I am trying to use Member Months Fraction in a calculation at the Total level in each of the buckets. The table on the left has Member Months Fraction in each of the cells. I want that number to be 667,190 in every cell. When I use Total like on the table on the right, all of the member months fall into the Null() number of visits.
How do I use that 667k total across all cells?
The dimension that I am using takes a field called visits and counts up the number of visits someone has and buckets them into the ranges. I am using set analysis in that measure because I want specific types of visits.
I do not have access to the data model and only have access to the front end.
I gave it a shot and it doesn't seem to respect the Total function. I got the same results as before. I wonder if the calculated dimension is messing with the total somehow.
To say it in words, I want all of the member months associated with the year to be in every visit cohort. My goal is to calculated a visits per 1,000 which is the number of visits/total member months*12000
Here is the same table and just using Sum(Total Member Months). It places all 3 years of member months in each cell. If I change the expression to Sum(Total <Incurred Year> Member Months) it puts all of the numbers just like in the original image where they are the fraction of the 670k.