topic Re: Having issues to elimniate duplicate in QlikView

Having issues to elimniate duplicate

Tue, 06 Oct 2015 02:19:57 GMT

I am facing a challenge to remove duplicates of employee numbers in a pivot..any help would be appreciated...

Re: Having issues to elimniate duplicate

sunny_talwar — Tue, 06 Oct 2015 02:53:20 GMT

What happens when you select 'Suppress When Value Is Null' for your third dimension (I think it says DO, but not completely sure)

Re: Having issues to elimniate duplicate

Tue, 06 Oct 2015 02:56:19 GMT

It does reduce the data but it takes down the real values as well...I want to eliminate only dupes..

Re: Having issues to elimniate duplicate

settu_periasamy — Tue, 06 Oct 2015 03:00:21 GMT

Hi Venkat,

what about your expressions? is it possible to post the sample qvw?

Re: Having issues to elimniate duplicate

Tue, 06 Oct 2015 03:14:36 GMT

expression is a simple one thou

Re: Having issues to elimniate duplicate

Tue, 06 Oct 2015 03:17:35 GMT

count(DISTINCT{$<BU_NAME-={NULL}>}EMPLID)

Re: Having issues to elimniate duplicate

settu_periasamy — Tue, 06 Oct 2015 03:22:39 GMT

Hi Venkat,

is it possible to post the sample qvw?

Re: Having issues to elimniate duplicate

Anonymous — Tue, 06 Oct 2015 03:38:37 GMT

Hi Venkat,

Check the expression once, you have added ' - ' after BU_Name.

Hope it helps!!

Re: Having issues to elimniate duplicate

Anonymous — Tue, 06 Oct 2015 03:45:58 GMT

Post sample application so that it will be easy to give solution

Thank You,

Re: Having issues to elimniate duplicate

avinashelite — Tue, 06 Oct 2015 04:39:08 GMT

try like : add a calculated dimension

if(len(BU)>0,BU,null()) and then check on the suppress null in dimension

Re: Having issues to elimniate duplicate

sujeetsingh — Tue, 06 Oct 2015 06:01:47 GMT

First of all at first it seems there is one to many relationship in data model due to null values. Please provide a complete details of the table you are using and the data you are reloading .

Re: Having issues to elimniate duplicate

SreeniJD — Tue, 06 Oct 2015 06:08:44 GMT

Venkat -

Try this

Sometimes, if you have some space or anything in the source data, it will not be treated as NULL.. so use function such as len(trim(field_name))=0...

HTH

Sreeni