Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
himani_a_agrawa
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()) "

1 Solution

Accepted Solutions
sunny_talwar

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
Arthur_Fong
Partner
Partner

Can you provide a sample app?

himani_a_agrawa
Contributor II
Contributor II
Author

Attached is the mock file for your reference. 

sunny_talwar

For highlighting, try this

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

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

himani_a_agrawa
Contributor II
Contributor II
Author

Thanks Sunny, this worked. 

 

Thank you so much.

sunny_talwar

Awesome 🙂