topic Re: Display only largest of repeating Values in QlikView

Display only largest of repeating Values

Anonymous — Tue, 03 Dec 2013 08:13:04 GMT

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

Re: Display only largest of repeating Values

tresB — Tue, 03 Dec 2013 08:35:28 GMT

Yes idea is like attached sample.

Re: Display only largest of repeating Values

Tue, 03 Dec 2013 09:06:24 GMT

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);