Remove duplicate Entries in front end

[swatitomar]

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.

[Anil_Babu_Samineni]

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

[avinashelite]

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

[swatitomar]

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.

[avinashelite]

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

[swatitomar]

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

[avinashelite]

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 ?

[swatitomar]

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.

[swatitomar]

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.

[avinashelite]

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