Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display only largest of repeating Values

Hi,

I have a table (left), that I would like to convert into table (right). For each item in the original list, only the values corresponding to the largest number of repetition should be displayed.

Any idea?

Michael

2 Replies
tresesco
MVP
MVP

Yes idea is like attached sample.

Not applicable
Author

You can also make this transformation during the load in edit script window. Below example based on load from Excel file (table like in your example). Not very pretty solution.. but it works;)

Load max(REPETITION) as REPETITION

,ITEM

From data.xlsx

(ooxml, embedded labels, table is Sheet1)

Group by ITEM;


INNER JOIN

LOAD ITEM

,REPETITION

,VALUE

FROM

data.xlsx

(ooxml, embedded labels, table is Sheet1);