If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi, how to suppress duplicates in my dimension.
In my dimension use the next sentence to show Producto
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
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