Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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 (4)
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.

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.

View solution in original post

Javanshir_Mustafayev
Contributor III
Contributor III

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)

Javanshir_Mustafayev
Contributor III
Contributor III

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

GetSelectedCount(issue) shows zero.