topic Re: Remove duplicate Entries in front end in QlikView

Remove duplicate Entries in front end

swatitomar — Wed, 03 May 2017 04:49:03 GMT

Hi All,

Want to remove the duplicate entries from pivot table.

I have 2 table with multiple fields ,1 table name is A and another one is B .

In both table i have some common fields

like SerialNo,

Dealer_Code,

Defect_Codes,

Partno

there are many more fields in table.

ex i have Claim Date , Failure...... in B table

Now query is: i have 10 rows in A table and 1 row with field value in table B ..

One row is matching in A and B table.

and i want 9 rows data of table A and 1 of table B as same value of one row exist in A and B.

Note: i want i front end not in script.

What will be the expression?

Thanks in Advance.

Re: Remove duplicate Entries in front end

Anil_Babu_Samineni — Wed, 03 May 2017 04:53:34 GMT

With out showing data may be tricky to reply. Would you able to show data

Re: Remove duplicate Entries in front end

avinashelite — Wed, 03 May 2017 05:46:28 GMT

You need to share the details like

1.How the data is

2.How the 2 tables are connected

3.Which are the columns your using the front end

4.sample data with required output

Re: Remove duplicate Entries in front end

swatitomar — Wed, 03 May 2017 08:49:39 GMT

Hey Hi,

PFA .

In the attached scenerio you can check

the starting fields with the same value like

Link_Dealer

job No.

Link_Serial

Link_part

Hours Reading

as u can check same line with

Txn type= Warranty comes with the same value as of txn type= Job Card

There are 6 lines but want 5 lines only.

What i want is ouptut will give the warranty line not the Job Line.

What to remove the duplication on the basis of above mentioned fields.

I hope this will help you.

Re: Remove duplicate Entries in front end

avinashelite — Wed, 03 May 2017 09:11:05 GMT

Ok, apply the filter for Txn type = Job Card and check ..you should get the results ..if still facing issues share the sample app

Re: Remove duplicate Entries in front end

swatitomar — Wed, 03 May 2017 10:06:53 GMT

I didn't get the result by this.

I want warranty line to be shown if shown duplication come and

user req. is if they don't select anything then duplication will remove automatically .

All line of job card and if duplicate then Warranty lines

Re: Remove duplicate Entries in front end

avinashelite — Wed, 03 May 2017 10:16:19 GMT

I am confused !! as per your screen shot the data is not duplicated when you check the combination of all the fields then every row is unique .remove the Link_partno column and check ...Qlikview remove the duplicates automatically ..

your try to hide and un-hide the data based on selection ? if so you are you using any button for this ?

Re: Remove duplicate Entries in front end

swatitomar — Wed, 03 May 2017 18:11:50 GMT

Hi Avinash,

As i said , want unqine row in case data of mentioned 5 fields in appl. have same value in job and warranty hen pivot table shuld show single line n dat is of Warranty data line.

I have attach the appl.withh a ex.

in actaul i have list box that show field

Type
Job
Warranty
Both

If user select Both then the condition will apply otherwise not and if doesnt then full data with duplication value.

It little bit tricky.

Hope this will help you in finding my ans.

Re: Remove duplicate Entries in front end

swatitomar — Thu, 04 May 2017 04:36:45 GMT

As i said , want unqine row in case data of mentioned 5 fields in appl. have same value in job and warranty hen pivot table shuld show single line n dat is of Warranty data line.

I have attach the appl.withh a ex.

in actaul i have list box that show field

Type
Job
Warranty
Both

If user select Both then the condition will apply otherwise not and if doesnt then full data with duplication value.

It little bit tricky.

Hope this will help you in finding my ans.

Re: Remove duplicate Entries in front end

avinashelite — Thu, 04 May 2017 05:35:53 GMT

Problem is with the set analysis you have included both the job type and hence respective of the selection it showing both the Type just use

count(1) and try

Re: Remove duplicate Entries in front end

swatitomar — Thu, 04 May 2017 06:04:37 GMT

Hey ,

i have tried with

Count(1) and

count( distinct Link_Dealer_Code &Link_SerialNo& Link_Partno&Job_No&Hours_Reading)

Both not working as i want to remove the duplicate line of Job not warranty.

U tried the above 1 in my Attached app?

Re: Remove duplicate Entries in front end

avinashelite — Thu, 04 May 2017 06:28:46 GMT

If I understood correctly ..

you have 2 table (which is not shown in the current example app ) and you have few rows in common in both the tables and when the above mentioned selection are made you need the row from one of the tables i.e either from A or B ? if yes then you need to add an Identifier dummy column in both the table like below

Table_A:

'A' as Identifier

....

Table_B:

'B' as Identifier

....

And use this field in the set analysis or as a filter box to get the desired result

Hope this helps you