topic Re: How could I get the 5 same items? in QlikView

How could I get the 5 same items?

Fri, 23 Dec 2011 19:03:55 GMT

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

How could I get the 5 same items?

Anonymous — Fri, 23 Dec 2011 19:20:00 GMT

Try putting a counter in your script.

RowNo ()

How could I get the 5 same items?

Fri, 23 Dec 2011 19:59:33 GMT

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

thanks!!

Re: How could I get the 5 same items?

johnw — Wed, 28 Dec 2011 01:04:24 GMT

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.

How could I get the 5 same items?

Wed, 04 Jan 2012 23:30:57 GMT

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