Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
/j
May be something like this:
LOAD Column1,
Column2,
If(Column1 = Colimn2, 'Duplicate', 'No-duplicate') as Check
FROM Source;
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)
QlikView has front end (UI) and back end (scripting). Are you trying to do this on the front end of the application?
Yes. Need a filterbox in the sheet to identify the duplicates.
maybe a listbox with this expression
=[User Name] = [User Name2]
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
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
Tx
Nakul
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
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