topic Re: Bar chart value label in App Development

Bar chart value label

Anonymous — Fri, 17 Nov 2017 09:40:19 GMT

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.

Re: Bar chart value label

sunny_talwar — Fri, 17 Nov 2017 13:37:37 GMT

Both the charts use the same expression?

Re: Bar chart value label

Anonymous — Fri, 17 Nov 2017 17:29:36 GMT

‌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..

Re: Bar chart value label

sunny_talwar — Fri, 17 Nov 2017 18:45:19 GMT

I am not sure what might be causing this? Would you be able to share a sample for us to see the issue?

Re: Bar chart value label

joblette — Fri, 17 Nov 2017 21:16:32 GMT

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.

Re: Bar chart value label

Anonymous — Mon, 20 Nov 2017 08:33:48 GMT

Hi, just realised this is most likely the case. Am trying to check and fix the null rating, thanks all for the help!