topic Re: Allow duplicates in qlikview chart in QlikView

Allow duplicates in qlikview chart

Fri, 05 Sep 2014 07:10:28 GMT

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 — Fri, 05 Sep 2014 07:16:22 GMT

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

Fri, 05 Sep 2014 07:18:46 GMT

HI Prajna,

U can Use ROWnO() .

Thanks !!

Fri, 05 Sep 2014 07:18:46 GMT

SORRY I CANT DO THAT

Regards,

Prajna

Fri, 05 Sep 2014 07:19:44 GMT

FOr Example,

LOAD * INLINE [

ID, Name, DateLogged, Status, Approved

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

Fri, 05 Sep 2014 07:27:01 GMT

cant i do any chart settings?

Regards,

Prajna