Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xding
Contributor II
Contributor II

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

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.

2 Solutions

Accepted Solutions
abhijitnalekar
Specialist II
Specialist II

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.

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

xding
Contributor II
Contributor II
Author

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.

View solution in original post

5 Replies
abhijitnalekar
Specialist II
Specialist II

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.

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
xding
Contributor II
Contributor II
Author

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
Specialist II
Specialist II

Hi @xding ,

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

you can check the same with isNum function

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
xding
Contributor II
Contributor II
Author

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

xding
Contributor II
Contributor II
Author

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.