topic mark duplicates? in QlikView

mark duplicates?

Sun, 11 Mar 2012 11:49:41 GMT

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

mark duplicates?

swuehl — Sun, 11 Mar 2012 12:03:01 GMT

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

mark duplicates?

Sun, 11 Mar 2012 12:22:00 GMT

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.

mark duplicates?

swuehl — Sun, 11 Mar 2012 12:52:20 GMT

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

mark duplicates?

Sun, 11 Mar 2012 13:19:07 GMT

thank you very much,its work.