topic Re: Eliminate duplicate's in QlikView

Eliminate duplicate's

Pujitha — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a question- Suppose for particular column(say id) we have different marks in another column. But my question is if I am having same id with same marks while calculating average and percentage am not getting the right value because of that duplication. Can you tell me how to eliminate that please respond asap.Thanks!!

Id Marks

CD-IM22 12

Like this I have when I am doing the avg and percentage in the expression it is taking three- 12's instead of one-12 .How to eliminate that one. Please let me know. Anything we can do in scripting ??

Re: Eliminate duplicate's

wade12 — Mon, 05 Nov 2018 15:28:37 GMT

Try using Load Distinct in script

Re: Eliminate duplicate's

Pujitha — Mon, 05 Nov 2018 15:31:49 GMT

Without Distinct -I need some thing else

Re: Eliminate duplicate's

kevincagle — Mon, 05 Nov 2018 15:46:05 GMT

What is the expression you are currently using? Im learning the more information you provide initially the more accurate a response will be.

Re: Eliminate duplicate's

Mark_Little — Mon, 05 Nov 2018 15:49:24 GMT

Hi,

Hard to suggest a fix without understanding the data and the real issue. Why is they duplicates? is it a data modelling issues? is a data issue?

One options maybe to make a new aggregate table that holds the distinct values for this calculation.

Mark

Re: Eliminate duplicate's

Pujitha — Mon, 05 Nov 2018 15:52:38 GMT

I am using only function.But in the percentage the facing the issue. Average I am good with it. I used only function in the expression of the pivot chart.

Re: Eliminate duplicate's

sunny_talwar — Mon, 05 Nov 2018 15:52:53 GMT

Try this

Avg(Aggr(Only(Marks), Id))