topic Re: repeated records in QlikView

repeated records

Thu, 15 Aug 2013 17:14:32 GMT

HI

i have some records that are repeated in my table, how can i do to show the repeated data in another table?

example?

atendentes_link]:

load * inline [atendente, link

danilo torres, 6060

ramon rios, 7070

danilo torres, 7070

fabiola santos, 6060

jeferson, 7070

];

"danilo torres" is repeated, i wanna put the repeated data and show in another table.

thanks for your help

Re: repeated records

swuehl — Thu, 15 Aug 2013 17:17:08 GMT

It depends what you want to achieve, but you can just create a list box in the front end of field atendente, and enable 'Show frequency' in list box properties - general tab. Sort by frequency desc.

Re: repeated records

Gysbert_Wassenaar — Thu, 15 Aug 2013 17:23:28 GMT

Try:

atendentes_link:

load *, if(exists(atendente),1,0) as Flag inline

[atendente, link

danilo torres, 6060

ramon rios, 7070

danilo torres, 7070

fabiola santos, 6060

jeferson, 7070

];

Result:

load atendente

resident atendentes_link

where Flag =1;

left join(Result) load atendente, link as link2

resident atendentes_link;