Distinct data in columns

[Javanshir_Mustafayev]

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

[micheledenardi · Accepted solution]

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.

[Javanshir_Mustafayev]

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]

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

[Javanshir_Mustafayev]

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]

Hi,

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

[Javanshir_Mustafayev]

GetSelectedCount(issue) shows zero.