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: 
Not applicable

mark duplicates?

hi all,

i want to color in my chart dimension that are duplicates, for exp:

dimensions:

sales rep      USERS

eric                 A

sam                B

haya               C

i want to mark in red color users that have two "sales rep":

sales rep          USERS

eric                    A

sam                   A

how can i do it?

thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If you want a list of USERS with duplicates, you could also use a list box, with a field expression (select <EXPRESSION> from the field drop down on general tab of list box properties) like

=aggr(if(count(DISTINCT [sales rep])>1, USERS), USERS)

I haven't fully understood your last answer, are you using a pivot or a straight table? With what dimensions in what order? You can force a pivot to fully expanded on presentation tab. Or use a straight table instead.

You should use at least the two dimensions USERS and sales rep.

Hope this helps,

Stefan

View solution in original post

4 Replies
swuehl
MVP
MVP

Use a background color attribute expression like

=if(count(total<USERS> distinct [sales rep])>1,lightred())

for your USERS dimension (open the attributes by clicking on the plus sign next to the dimension on dimension tab).

Hope this helps,

Stefan

Not applicable
Author

thank you, this is good but he color only if i open two that the same he dont tell me if only one user is open("-" sign)

do you know how to make buton that gives me al the duplicates?

thank you for the answer.

swuehl
MVP
MVP

If you want a list of USERS with duplicates, you could also use a list box, with a field expression (select <EXPRESSION> from the field drop down on general tab of list box properties) like

=aggr(if(count(DISTINCT [sales rep])>1, USERS), USERS)

I haven't fully understood your last answer, are you using a pivot or a straight table? With what dimensions in what order? You can force a pivot to fully expanded on presentation tab. Or use a straight table instead.

You should use at least the two dimensions USERS and sales rep.

Hope this helps,

Stefan

Not applicable
Author

thank you very much,its work.