Qlik Sense, bar chart not showing all values

[#1]

Hello

Iam currently learning Qlik Sense and trying to create a qv source twitter connection.

I have managed to get the data and store them in qvds.

I am concatinating all the data in load script and then trying to show the Top Followers Count per Tiwtter UserName,

But i can see that some Twitter Names doesnt get picked up in Bar Chart.

For Example Twitter Name " Star Wars " has 1,85 m followers, but doesnt show on the Top Followers bar chart .

I am attaching the qvf, and qvd so you can see for yourself, all help will be much appriciated.

[prabhuappu · Accepted solution]

Hi,

Checked your QVF file and found that you haven't used any aggregate function in the expression. And for "Star Wars" multiple values are there in "SearchAdvanceduser_followers_count" column. see the below chart (Both SearchAdvanceduser_name and SearchAdvanceduser_followers_count columns are dimensions)

If you use add an aggregate function then it will be showed in the bar chart as well.

As a best practice you should always use any aggregate function in the chart expressions. Also validate the data if you think the value is incorrect

Regards,

Prabhu Appu

[#3]

You are absolutely right, thank you !

[#4]

sum(distinct SearchAdvanceduser_followers_count)

I used this expression and i get all the right amount of values( Followers ) per Twitter Name

but not in Star Wars,

Star Wars has 1,93 M followers, with this expression i get 3,81 M ..

But it seems all the other twitter names have the right values