Duplicate values in dimension

[Ronald]

Hi, how to suppress duplicates in my dimension.

In my dimension use the next sentence to show Producto

/* AGGR(DUAL(Producto,RowNo(TOTAL)),Medico,Producto)*/

[Or]

Why not simply use Producto as a dimension? Qlik automatically groups matching values together in the table and only displays each unique value once in the selection.

[Ronald]

I don't use Product because the Product dimension is not ordered; and I need for each Medico to order their products in descending order

[Or]

Why not order by Y-value (first expression), if you are in April 2020 version; or, order the dimension using a custom formula matching the one you used for dual() here? Using dual() in this case presumably creates multiple instances of the same text value, each with a different numeric value for the dual, because the product can appear under multiple Medico.

[Ronald]

It is correct, but using / * AGGR (DUAL (Product, RowNo (TOTAL)), Medical, Product) * / solves this problem of multiple records; but the products are not ordered descending, Productos in each Medico

[ArnadoSandoval]

Hi @Ronald - Sorry @Or  for getting into your thread

Last week I assisted another user trying to sort the second field on a Pivot table, and we managed to find a solution, perhaps you may find this topic Qlik Sense Pivot Table Custom Sorting by Measure 2 Dim and 2 columns  helpful

Hope this helps,

[Ronald]

With the expression /*AGGR(DUAL(Producto,RowNo(TOTAL)),Producto)*/ resolved the issue in the dimension show unique values, but  don´t sort Producto in each Medico

[Or]

@ArnadoSandovalThere's never a need to apologize for stepping into a thread - we're all just trying to help someone out here!