I have a table loaded which contains these fields on top of others (omitted):
autonumber("A"&"B"&C&"D") as %ItemID,
I have a table created with dimensions of Month and rating. The measure is Count(distinct [%ItemID]).
The total does not compute correctly, as shown below. It should be 59 and not 60 by adding up the 3 ratings. Any ideas on what could be the cause of the discrepancy? Thank you.
Solved! Go to Solution.
There is only one bar chart created. Sorry if my phrasing was misleading, am relatively new to Qlik. When hovering over a month, the values are correct for the respective ratings but the total value label is off by 1..