Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Identify duplicate entries

Hi,

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

User NameUser Name2
TestNoTest
TestTest
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!

/j

9 Replies

Re: Identify duplicate entries

May be something like this:

LOAD Column1,

          Column2,

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

FROM Source;

Not applicable

Re: Identify duplicate entries

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

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

Not applicable

Re: Identify duplicate entries

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

MVP
MVP

Re: Identify duplicate entries

maybe a listbox with this expression

=[User Name] = [User Name2]

Not applicable

Re: Identify duplicate entries

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

nakul1001
Contributor II

Re: Identify duplicate entries

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

Screen1.JPG

Screen2.JPG

Tx

Nakul

Not applicable

Re: Identify duplicate entries

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,

/j

nakul1001
Contributor II

Re: Identify duplicate entries

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

Community Browser