Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Duplicate values in dimension

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)*/

Pivot Dimension Repeating.PNG

Labels (1)
7 Replies
Or
Master
Master

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
Contributor III
Contributor III
Author

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
Master
Master

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
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

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,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Ronald
Contributor III
Contributor III
Author

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

pivot3.PNG

 

Or
Master
Master

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