Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Display only records where a dimension entry comes up more than once

Hi everyone

I'm having trouble with a straight table, where I have to display only records where a certain dimension's value comes up more than once.

Lets say I have a dimension called ID, and then Username as an additional dimension. The end result must be that the chart must only show entries where the ID column is not distinct, i.e. if ID number 1234 is associated with more than one Username, show those entries, otherwise don't.

 

Any help will be appreciated.

Labels (1)
4 Replies
Highlighted

What is your expression that you use? Assuming your expression is Sum(Measure), change it to this

Sum({<ID = {"=Count(DISTINCT UserName) > 1"}>}Measure)
Highlighted
Contributor
Contributor

Thank you for your quick feedback.

Basically the straight table must act like a tablebox, where I only display Customer information where an ID is associated with more than 1 customer

Highlighted

So, may be try this

Dimensions

ID
Customer

Expression

Sum({<ID = {"=Count(DISTINCT Customer) > 1"}>}Measure)

and on the presentation tab of the chart properties hide the expression so that you only see two dimensions

Highlighted
Partner
Partner

Maybe try
Customer as dimension
Expression
Only({<ID = {"=Count(DISTINCT Customer) > 1"}>}ID)