Filters visual Issue

[Karthick30]

Hi Team,

 I have 2 tables which was joined by using primary Key(Employee Number).

In one of the filter , I am using if condition like below

Due to this , If I am selecting any of the field in that filter, I am seeing all 3 selections in filter area.

End users don't want to see multiple filters in top area. 

Same Issue is there for KPI and its detailed info Page. I have 5 KPI's . Each KPI is redirected to one common table. by clicking on anyone KPI , its redirecting to that table with all filters applied on top. Any way to fix it please

[vchuprina · Accepted solution]

Hi,

You can use HidePrefix in your script, at the start of your script add the following variable

set HidePrefix='_' ;

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/SystemV...

After this rename fields that shouldn't be visible in the selection bar and reload the application

For instance

Invalid as _Invalid 
AccountStatus as _Account Status

After reloading selection in fields that names start by _ will be invisible in the selection bar.

Please remember that after reloading you should update your condition and other expressions where you use renamed fields

Regards,

Vitalii

[Karthick30]

perfectly worked. Thanks much