Allow duplicates in qlikview chart

[#1]

Hi All,

By default qlikview always take distinct records can i overide this.

Problem:

I have a requirement where i need show images for emotions based on text data.

In database there are duplicate text message but different emotions.

But in qlikview em getting only one text message and emotions are empty while displaying in a chart.

can anyone suggest how to overide this?

I need to have all ext and respective emotions..now qlikview is confused.

PLlease suggest ASAP.

Thank you

Regards,

Prajna

[Anonymous]

Can you provide a sample qvw.... with data..

[#3]

HI Prajna,

U can Use ROWnO() .

Thanks !!

[#4]

SORRY I CANT DO THAT

Regards,

Prajna

[#5]

FOr Example,

A:

LOAD * INLINE [

    ID, Name, DateLogged, Status, Approved

    123, Joe, 1/1/2010, OK, Yes

    123, Joe, 1/1/2010, OK, Yes

    789, Joe, 1/3/2010, OK, No

    100, Mary, 2/4/2010, OK, No

];

LOad * ,RowNo() as Row Resident A;

Drop Table A;

and USe Row  in Dimension

[#6]

cant i do any chart settings?

Regards,

Prajna