Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

"Hi All,  Please help me on this topic. I know there are many post regarding it, but couldn't find relevant solution. Here is the detailed description of my issue:I have a straight table, where I am showing DeviceName, IP address, Country etc, on the basis of some expression in expression tab and some calculated dimension also. Now After calculation, there are list of values that appears in the table, have duplicates, or can say repetitive values. Now my requirement is to give a user a button, so that they can see: 1. duplicate records, (device name) 2.  duplicate records, (ip_address) 3. Filter out only duplicate records in the table( device name /IP) like we used to do in excel.  Also, for highlighting , i used the below formula, but when I used the same formula to highlight another column in the same table, it is not highlighting.  if(DeviceName = below(DeviceName) or DeviceName= above(DeviceName) , Green()) "

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

Here is a solution for Showing Duplicate when Duplicate Name button is clicked

Button Action -> Set Variable

Variable = vToggleViz6
Value = '=If(vToggleViz6 = 1, 0, 1)'

image.png 

Change the dimension DeviceNameAll to 

=If(vToggleViz6 = 1, DeviceNameAll, If(Aggr(NODISTINCT Count(DISTINCT apparent_ip), DeviceNameAll) > 1, DeviceNameAll))

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

Can you provide a sample app?

Contributor II
Contributor II

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

Attached is the mock file for your reference. 

Highlighted

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

For highlighting, try this

=If(Aggr(NODISTINCT Count(DISTINCT apparent_ip), DeviceNameAll) > 1, Green())
Highlighted

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

Here is a solution for Showing Duplicate when Duplicate Name button is clicked

Button Action -> Set Variable

Variable = vToggleViz6
Value = '=If(vToggleViz6 = 1, 0, 1)'

image.png 

Change the dimension DeviceNameAll to 

=If(vToggleViz6 = 1, DeviceNameAll, If(Aggr(NODISTINCT Count(DISTINCT apparent_ip), DeviceNameAll) > 1, DeviceNameAll))

View solution in original post

Highlighted
Contributor II
Contributor II

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

Thanks Sunny, this worked. 

 

Thank you so much.

Highlighted

Re: Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

Awesome 🙂