How could I get the 5 same items?

[#1]

Hi all, I have 5 components of an item, how could I get the 5 items in qlikview even if is the same id, description, quantity, etc. I need it to be showed 5 time in this case.

I attached the app for a better understand.

Thank you!!

[Anonymous]

Try putting a counter in your script.

RowNo ()

[#3]

Ok, but Im not too familiar with RowNo() could you please explain it in a general way where to use it?

thanks!!

[johnw]

If I understand the question:

Estructuras:
LOAD Material                     as Material_Estructuras,
     Centro,
     [Cantidad Base],
     [No. Nivel],
     Posición,
     [No. Componente],
     [No. Componente]            as %Key_Componente,
     [Texto Componente],
     [Cantidad de componente],
     [Cantidad de componente]    as Cantidad_Componente_Estructuras,
     [Unidad de medida],
     recno() as [Recno]
FROM
Estructuras_Correcto.xlsx
(ooxml, embedded labels, table is Sheet1);

However, it still won't display five times in the list box because the list box just lists the possible values.  The list box doesn't care how many times those values appear in the data.  To see five rows, you would need a tablebox or chart and you'd need to include the new [Recno] field.

[#5]

Yes!! that´s what
I was looking for Jhon, thank you very much!!