topic Re: Identify duplicate entries in QlikView

Identify duplicate entries

Mon, 15 Feb 2016 19:00:55 GMT

Hi,

I am trying to create a filter box which shall identify duplicate entries in two columns (on the same row).

User Name	User Name2
Test	NoTest
Test	Test
Duplicate	Duplicate

I need a text box or something equivalent that simply states 'Duplicates' based on the fact that there are two matches in the table above. Clicking 'Duplicates' should filter corresponding table.

Any assistance is highly appreciated!

Re: Identify duplicate entries

sunny_talwar — Mon, 15 Feb 2016 19:08:41 GMT

May be something like this:

LOAD Column1,

Column2,

If(Column1 = Colimn2, 'Duplicate', 'No-duplicate') as Check

FROM Source;

Re: Identify duplicate entries

Mon, 15 Feb 2016 19:23:53 GMT

Hi,

Maybe I should have been clearer. Its not during Load or in SQL, its in Qlikview. Unless you are referring to a functionality in Qlikview I have no clue about (quite a rookie)

Re: Identify duplicate entries

sunny_talwar — Mon, 15 Feb 2016 19:42:59 GMT

QlikView has front end (UI) and back end (scripting). Are you trying to do this on the front end of the application?

Re: Identify duplicate entries

Mon, 15 Feb 2016 19:45:30 GMT

Yes. Need a filterbox in the sheet to identify the duplicates.

Re: Identify duplicate entries

maxgro — Mon, 15 Feb 2016 19:48:09 GMT

maybe a listbox with this expression

=[User Name] = [User Name2]

Re: Identify duplicate entries

Mon, 15 Feb 2016 20:57:30 GMT

That kind of works, much the same way as my other one;

=if( = , 'Self Assignment', 'No Self Assignment')

But somehow it still pulls in other rows. However, the rows it do pull in have the same User Name and Changed By name as the ones that do match.

Example:

User Name Changed By

Re: Identify duplicate entries

Anonymous — Mon, 15 Feb 2016 22:17:29 GMT

One way to achieve this would be to add a flag_column in the table (load script) that compares the User Name and Changed by Name columns. Using this flag_column we can control selections and then using a variable in the UI to toggle the buttons. Take a look at the screenshot and the attached .qvw

Nakul

Re: Identify duplicate entries

Mon, 15 Feb 2016 23:50:55 GMT

Hi,

Thanks for this. However, I am unsure how I can use this so I load data from SQL-table? I understand if you want to add columns and fields manually, but that’s not possible in my case.

Any chance you can assist on that?

Thanks again,

Re: Identify duplicate entries

Anonymous — Tue, 16 Feb 2016 03:54:31 GMT

My approach can work with a sql table too. So in place of an inline load query you can do the basic select... from db.tablename. The sql statement for resident load can be kept as is.

-nn