Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Pujitha
Contributor II
Contributor II

Eliminate duplicate's

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

CD-IM22            12                    

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 ??

1 Reply
wade12
Partner - Creator II
Partner - Creator II

Try using Load Distinct in script