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

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

himani_a_agrawa — Sat, 16 Nov 2024 02:03:48 GMT

"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()) "

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

Arthur_Fong — Fri, 01 Nov 2019 07:30:11 GMT

Can you provide a sample app?

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

himani_a_agrawa — Fri, 01 Nov 2019 10:26:22 GMT

Attached is the mock file for your reference.

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

sunny_talwar — Fri, 01 Nov 2019 11:29:24 GMT

For highlighting, try this

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

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

sunny_talwar — Fri, 01 Nov 2019 11:33:44 GMT

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)'

Change the dimension DeviceNameAll to

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

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

himani_a_agrawa — Tue, 05 Nov 2019 04:17:17 GMT

Thanks Sunny, this worked.

Thank you so much.

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

sunny_talwar — Tue, 05 Nov 2019 11:22:58 GMT

Awesome 🙂