Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)*/
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.
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
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.
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
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,
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
@ArnadoSandovalThere's never a need to apologize for stepping into a thread - we're all just trying to help someone out here!