topic Re: Load Distinct Data in QlikView

Load Distinct Data

jyothish8807 — Thu, 27 Jun 2013 05:46:51 GMT

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

Re: Load Distinct Data

Thu, 27 Jun 2013 05:56:10 GMT

It should get all data.

Could you post sample file?

Karthik

Re: Load Distinct Data

Gysbert_Wassenaar — Thu, 27 Jun 2013 06:00:22 GMT

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

Re: Load Distinct Data

jyothish8807 — Thu, 27 Jun 2013 06:06:16 GMT

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.

Re: Load Distinct Data

Thu, 27 Jun 2013 06:11:22 GMT

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

Re: Load Distinct Data

jyothish8807 — Thu, 27 Jun 2013 06:12:27 GMT

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.

Re: Load Distinct Data

Thu, 27 Jun 2013 06:43:50 GMT

Find attachment..

It look like working for me.

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

Karthik