Load Distinct Data

[jyothish8807]

Hi,

I have an Execl sheet which looks like this:

Doc ID	Name	Marks
112	a	21
112	b	22
134	c	34
135	d	33
135	a	44

But when i load this sheet in QV it dosent reads the repeating doc ids.

QV Data Looks like this.

Doc ID	Name	Marks
112	a	21
134	c	34
135	d	33

But i want complte Doc ID in my QV Straight chart.

How can i get this.

Regards

Jyothish KC

[#2]

It should get all data.

Could you post sample file?

Karthik

[Gysbert_Wassenaar]

You can use the firstsortedvalue function. Use Doc ID as dimension and as expressions min(Marks) and firstsortedvalue(Name, Marks). See attached example.

[jyothish8807]

This not what i want. This is what ian getting by default.I just want the exact data which is the excel sheet.

But QV is not reading the same doc id's as different value.

[#5]

RawData:LOAD * INLINE [
Doc ID, Name, Marks
112, a, 21
112, b, 22
134, c, 34
135, d, 33
135, a, 44

];

Take Dimension : Doc ID, Name

Exp : Sum(Marks)

Its showing all value..

regards-Bika

[jyothish8807]

No Bro, it takes only the unique value. If you call the Doc ID in List box also it will take the unique data only, not all the doc ids.Actually there is no primary key in this table.

[#7]

Find attachment..

It look like working for me.

Please do the change what all you did on your application and send me back..

Karthik