Listbox hide some values

[nvijay5757]

Hi,

in list box to hide some values. i have two filters 1. country 2. other  (in qlikview its working fine)

=if(WildMatch(Country,'india','USA','CANADA'),Country)

if i select 1st filter its working fine but when i select 2nd filter its not working in qliksense may i know any other alternative.

thanks

[lukas_]

Hello,

Do you have the option to create a new dimension in the script based on your calculation? It would be cleaner

[vinieme12]

You just need to wrap it in Aggr()

=Aggr(if(WildMatch(Country,'india','USA','CANADA'),Country),Country)

OR

=Aggr(only({<Country={'india','USA','CANADA'}>}Country),Country)

[nvijay5757]

Hi Vineeth,

Thanks

the Two expressions are working fine. in filter pane values are hiding but when i click on top selections filter hiding values also shown. any help for that.

[vinieme12]

No, there is nothing you can do about that on the front end

Best option Create a new field in your script

[nvijay5757]

Hi Vineeth,

i have tried using create a new field also not working for me. can you please suggest .

Ex:

Test:
LOAD * Inline[
'Extended Target'
india
USA
CANADA
UK ];

Table1:

'india' as Country

Table2:

'USA' as Country

Table3:

'CANADA' as Country

Final1:
LOAD

Modes,
Severity_Level,
Country,

Sum(Sev1)+Sum(Sev2)+Sum(Sev3) as Sevall,
Sum(Ext_Sev1)+Sum(Ext_Sev2)+Sum(Ext_Sev3) as Ext_Sevall

Resident New
Where IsNull(Modes)<>-1
Group By Modes,Severity_Level,Country;
DROP Table New;

NoConcatenate

Fina12:
LOAD
Modes&'|'&Country as key,

Sum(Sevall) as Sevall,
Sum(Ext_Sevall) as Ext_Sevall

Resident Final1
Group By Modes,Country;
DROP Table Final1;

like this way i have written code. in this i have two filters 1. country 2. Extended Target

in country filter we have to hide the value.

How can i create column from backend can you please help me in this.