Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table loaded which contains these fields on top of others (omitted):
autonumber("A"&"B"&C&"D") as %ItemID,
rating
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.
For me it looks like you have one ocuurence in July with no rating. But is just a guess, it is hard to say without seeing the app.
Both the charts use the same expression?
Hi,
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..
I am not sure what might be causing this? Would you be able to share a sample for us to see the issue?
For me it looks like you have one ocuurence in July with no rating. But is just a guess, it is hard to say without seeing the app.
Hi, just realised this is most likely the case. Am trying to check and fix the null rating, thanks all for the help!