Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Finding the duplicated and changed values in a table

I have a table like which shows the staff name, the unit they belong to and their login time to a system.

User     Unit                                LoginTime

Jane      Customer Service         12.00

Jane      Customer Service         13.00

Jane      Customer Service         14.00

Peter     Sales & Marketing        22:00

Peter     Sales & Marketing        22:34

Peter     Sales & Marketing        07:00

David     Executive Office           14:00

David     Executive Office           15:02

David     Sales & Marketing        16:07

Now I want to create a table which display users that have moved units.

So I will have something like this

User          Unit                              LoginTime

David        Executive Office           15:02

David        Sales & Marketing        16:07

I am new to qlikview so any help would be much appreciated!!!

1 Solution

Accepted Solutions

See attached example.

talk is cheap, supply exceeds demand

View solution in original post

3 Replies

See attached example.

talk is cheap, supply exceeds demand
Not applicable

Thank you so much for your help.  Really do appreciate it!

As I am very new to qlikview, I am wondering if you could briefly explain this

=max({<AuthenticatedUser={"=count(distinct [AD User department])>1"}>}[Start DateTime])

I am struggling to understand what the count(distinct [AD User department])>1 would produce, is it just a number?

Also is it possible to get rid of the circle part below?



This is a filter: {<AuthenticatedUser={"=count(distinct [AD User department])>1"}>}. It will select those AuthenticatedUser values that have more than one Unit. That's what the count distinct is for.

You can set the Total mode of the expression to No Totals to disable the total of the expression.

talk is cheap, supply exceeds demand