How to display Sum of Views with the same ID and Name in Qlik Sense?

[xding]

Hi all,

I have a problem:

I have the original table like below, there are  attributes ID, Time, Name, Views in Column.

ID	Time	Name	Views
0001	2021-01-31	AAA	30
0002	2021-01-31	BBB	30
0001	2021-02-20	AAA	50
0002	2021-02-20	BBB	20

I would like to show using Table chart, when ID and name are the same of one row, sum the two rows of Views to show in the below table. The time is useless in the chart, can be removed in the chart.

ID	Name	Views
0001	AAA	80
0002	BBB	70

Any recommendation? Thank you.

[abhijitnalekar · Accepted solution]

Hi @xding,

You can remove the time column from the table and use expression sum(views) for the view column, It will automatically group the data accordingly.

[xding]

Hi Abhijit, thanks for timely help. I can't remove Time column from the original table. I didn't add Time field in Table chart and use sum(views) but don't know why in chart, these are still multiple rows for the same ID and Name. 😅

[abhijitnalekar]

Hi @xding ,

In that case, please check if your view column has Int datatype.

you can check the same with isNum function

[xding]

Hi Abhijit, thanks for reminder. As checked, yes, it's integer. 

[xding · Accepted solution]

Hi Abhijit, thanks again for your help. I found the issue that I have created. I have only added Views column into visualization rather than create measure to use sum(views) then added to visualization. Right now, it works as you said. Thanks a lot.