Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Javanshir_Mustafayev
Contributor III
Contributor III

Distinct data in columns

Hello guys, 

I've a table chart where Jira issues are shown and filtered but there are multiple entries due to issues from Jira tend to move from sprint to sprint and this causes duplicate rows in chart.

How can I remove the duplicates? 

The issue url column expression is ='https://mycompany.atlassian.net/browse/' & issue

clipboard_image_0.png

 

Labels (3)
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

Since qlik sense table shows unique records only,  you have to remove from your table the columns which are causing the splitting (sprint column in your case) but duplicated records remains on your dataset.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

6 Replies
micheledenardi
Specialist II
Specialist II

Since qlik sense table shows unique records only,  you have to remove from your table the columns which are causing the splitting (sprint column in your case) but duplicated records remains on your dataset.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Javanshir_Mustafayev
Contributor III
Contributor III
Author

Ok this removed the duplicates, but there is another issue now. I've a counter of issues listed on the page, that is showing wrong numbers, what should I count to make sure the issues displayed are counted?

micheledenardi
Specialist II
Specialist II

Try to add DISTINCT on your expression: count(Distinct issue)

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Javanshir_Mustafayev
Contributor III
Contributor III
Author

sad this counts the whole number of issues. this table is already filtered so I don't need the total distinct values counted, only those that are shown on the screen

Ameya09
Partner
Partner

Hi,

Try Using GetSelectedCount() to get count of only selected value.

Javanshir_Mustafayev
Contributor III
Contributor III
Author

GetSelectedCount(issue) shows zero.