Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
QLIKMASTER2
Contributor
Contributor
‎2022-01-24 08:17 AM

listbox filed values restriction

Hi All,

 I have the field called Measures.

I have requirement here, there is a filed called  below fieldName .

In Frontend , in the filter box I need to remove the _CORP  field values .

Can anyone please help me out.

I dont want to restrict in the script level.

I need to restrict in the Front end Filter qliksense.

 

 

FieldName
ACTUAL_CONSIGNMENT_COST
ACTUAL_CONSIGNMENT_COST_CORP
ACTUAL_COST_IN_OTHER_PLANTS
ACTUAL_COST_IN_OTHER_PLANTS_CORP
ACTUAL_INHOUSE_PKG_LABOR_COST
ACTUAL_INHOUSE_PKG_LABOR_COST_CORP
ACTUAL_INHOUSE_PKG_MATERIAL_COST
ACTUAL_INHOUSE_PKG_MATERIAL_COST_CORP
ACTUAL_LABOR_OVERHEAD_COST
ACTUAL_LABOR_OVERHEAD_COST_CORP
ACTUAL_MATERIAL_COST
ACTUAL_MATERIAL_COST_CORP
ACTUAL_SUPPLIER_PKG_COST
ACTUAL_SUPPLIER_PKG_COST_CORP
ACTUAL_TOTAL_COST
ACTUAL_TOTAL_COST_CORP
ACTUAL_TOTAL_MATERIAL_COST
ACTUAL_TOTAL_MATERIAL_COST_CORP
ACTUAL_UPLIFT_COST
ACTUAL_UPLIFT_COST_CORP
AFFILIATE_DISCOUNTS
B10_PA_SERVICE_VAR_MKTG
B10_PA_SERVICE_VAR_MKTG_CORP
CASH_DISCOUNT
CASH_DISCOUNT_CORP
CHANNEL_DISCOUNTS
CONTRIBUTION_MARGIN
CONTRIBUTION_MARGIN_CORP
CORE_CASH_DISCOUNT
CORE_DEPOSIT_SALES
CORE_PURCHASES
CORE_PURCHASES_CORP
CORE_RESERVE_RELEASE
CORE_RESERVE_RELEASE_CORP
D20_SPW_TOTAL_EXPENSE
D20_SPW_TOTAL_EXPENSE_CORP
D21_SPW_MATERIAL_COST
D22_SPW_PARTS_MARKUP
D23_SPW_LABOR_WARRANTY
D24_SPW_MISCELLANEOUS
D25_SPW_WEB_INPUT
D25_SPW_WEB_INPUT_CORP
DEALER_ALLOCATED_WARRANTY_ATCONSTANT
DEALERS_TERMS_N_CONDITIONS
DIRECT_ACCOUNT_ALLOWANCE
E10_FREIGHT_INBOUND
E10_FREIGHT_INBOUND_CORP
E20_FREIGHT_OUTBOUND
E20_FREIGHT_OUTBOUND_CORP
E30_DUTIES
E30_DUTIES_CORP
EMERGENCY_ORDER_CHARGES
EXPORT_DISCOUNTS
EXTENDED_GROSS_ACTUAL_COST_ATCONSTANT
EXTENDED_STANDARD_COST_ATCONSTANT
FIFO
FIFO_CORP
FIXED_COST
FIXED_COST_CORP
G10_VARIABLE_DEPOT_EXPENSES
G10_VARIABLE_DEPOT_EXPENSES_CORP
G20_VARIABLE_SCRAP
G32_INVENTORY_ADJUSTMENT
G32_INVENTORY_ADJUSTMENT_CORP
G40_OTHER_VARIABLE_COST
G40_OTHER_VARIABLE_COST_CORP
GROSS_CLP
GROSS_CLP_ATCONSTANT
GROSS_CLP_UNALLOCATED
GROSS_CUSTOMER_PAID
GROSS_CUSTOMER_PAID_ATCONSTANT
GROSS_ESP_OEW
GROSS_ESP_OEW_ATCONSTANT
GROSS_ESP_OEW_UNALLOCATED
GROSS_RETAIL_REVENUE
GROSS_RETAIL_REVENUE_ATCONSTANT
GROSS_REVENUE
GROSS_REVENUE_ATCONSTANT
GROSS_SPW
GROSS_SPW_ATCONSTANT
GROSS_SPW_UNALLOCATED
GROSS_VEHICLE_WARRANTY
GROSS_VEHICLE_WARRANTY_ACTUAL_CONSIGNMENT_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_COST_IN_OTHER_PLANTS
GROSS_VEHICLE_WARRANTY_ACTUAL_INHOUSE_PKG_LABOR_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_INHOUSE_PKG_MATERIAL_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_LABOR_OVERHEAD_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_MATERIAL_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_SUPPLIER_PKG_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_TOTAL_COST
GROSS_VEHICLE_WARRANTY_ACTUAL_UPLIFT_COST
GROSS_VEHICLE_WARRANTY_ATCONSTANT
GROSS_VEHICLE_WARRANTY_STANDARD_CONSIGNMENT_COST
GROSS_VEHICLE_WARRANTY_STANDARD_COST_IN_OTHER_PLANTS
GROSS_VEHICLE_WARRANTY_STANDARD_INHOUSE_PKG_LABOR_COST
GROSS_VEHICLE_WARRANTY_STANDARD_INHOUSE_PKG_MATERIAL_COST
GROSS_VEHICLE_WARRANTY_STANDARD_LABOR_OVERHEAD_COST
GROSS_VEHICLE_WARRANTY_STANDARD_MATERIAL_COST
GROSS_VEHICLE_WARRANTY_STANDARD_SUPPLIER_PKG_COST
GROSS_VEHICLE_WARRANTY_STANDARD_TOTAL_COST
GROSS_VEHICLE_WARRANTY_STANDARD_UPLIFT_COST
GROSS_VEHICLE_WARRANTY_SUPPLIER_OWNED_CORE
GROSS_VEHICLE_WARRANTY_SUPPLIER_OWNED_CORE_COST
GROSS_VEHICLE_WARRANTY_UNALLOCATED
I30_TOOLING_EXPENSE
I30_TOOLING_EXPENSE_CORP
INVENTORY_MANAGEMENT_ALLOWANCE_IMA
K10_ENGINEERING_EXPENSE
K10_ENGINEERING_EXPENSE_CORP
M10_SELLING_EXPENSE
M10_SELLING_EXPENSE_CORP
MEMO_NET_PIPP_POPP_PAYMENTS
MEMO_PIPP_POPP_ALLOWANCE
MISC_ALLOWANCE
MISC_REVENUE_REDUCTIONS
N10_FIXED_MARKETING
N10_FIXED_MARKETING_CORP
NET_CLP
NET_CLP_ATCONSTANT
NET_CUSTOMER_PAID
NET_CUSTOMER_PAID_ATCONSTANT
NET_ESP_OEW
NET_ESP_OEW_ATCONSTANT
NET_RETAIL_REVENUE
NET_RETAIL_REVENUE_ATCONSTANT
NET_REVENUE
NET_REVENUE_ATCONSTANT
NET_REVENUE_CORP
NET_SPW
NET_SPW_ATCONSTANT
NET_VEHICLE_WARRANTY
NET_VEHICLE_WARRANTY_ATCONSTANT
NORMAL_BUYBACK_RETURNS_TO_INV
NORMAL_BUYBACK_SCRAP
NORMAL_RETURNS
O10A_PSL_SUPPORT_COST
O10A_PSL_SUPPORT_COST_CORP
O10B_FIXED_DEPOT_DIRECT_DEPOT
O10B_FIXED_DEPOT_DIRECT_DEPOT_CORP
O20_OBSOLESCENCE
O20_OBSOLESCENCE_CORP
O45_OTHER_FIXED_COSTS_INCL_FCAS
O45_OTHER_FIXED_COSTS_INCL_FCAS_CORP
OTHER_COST
OTHER_COST_CORP
OTHER_COSTS
OTHER_COSTS_CORP
OTHER_REVENUE_DEDUCTIONS
PARTS_BONUS_SELL_IN
PDP
PIPP_POPP_RETURNS_GROSS
PRICE_DIFFERENCES
PRICE_PROTECTION
PROFIT_BEFORE_TAX
PROFIT_BEFORE_TAX_CORP
PURCHASE_DISCOUNT_OFFERS
PURCHASE_DISCOUNTS_SELL_IN
QUANTITY_DISCOUNTS
R10_INTEREST_INCOME_EXPENSE_OUTSIDE
R10_INTEREST_INCOME_EXPENSE_OUTSIDE_CORP
REIMBURSEMENT_COST
REIMBURSEMENT_COST_CORP
REMANUFACTURE_ALLOCATED_WARRANTY_ATCONSTANT
S40_OTHER_EXPENSE
S40_OTHER_EXPENSE_CORP
SALES_DISCOUNTS_SELL_OUT
SALES_MARKDOWN
SEED_PURCHASES
SEED_PURCHASES_CORP
SPD
STANDARD_CONSIGNMENT_COST
STANDARD_COST_IN_OTHER_PLANTS
STANDARD_INHOUSE_PKG_LABOR_COST
STANDARD_INHOUSE_PKG_MATERIAL_COST
STANDARD_LABOR_OVERHEAD_COST
STANDARD_MATERIAL_COST
STANDARD_SUPPLIER_PKG_COST
STANDARD_UPLIFT_COST
SUPPLIER_OWNED_CORE
SUPPLIER_OWNED_CORE_COST
T10_MEMO_STATISTICAL_ADJUSTMENTS
T10_MEMO_STATISTICAL_ADJUSTMENTS_CORP
TERMINATION_BUYBACK_RETURNS_TO_INVENTORY
TERMINATION_BUYBACK_SCRAP
TERMINATION_BUYBACKS
TERMS_AND_CONDITIONS
TERMS_AND_CONDITIONS_CORP
TOTAL_ADJUSTMENTS_TO_COST
TOTAL_ADJUSTMENTS_TO_COST_CORP
TOTAL_DISCOUNTS
TOTAL_DISCOUNTS_CORP
TOTAL_GROSS_WARRANTY
TOTAL_GROSS_WARRANTY_ATCONSTANT
TOTAL_GROSS_WARRANTY_UNALLOCATED
TOTAL_NET_WARRANTY
TOTAL_NET_WARRANTY_ATCONSTANT
TOTAL_PARTS_ALLOCATED_WARRANTY_ATCONSTANT
TOTAL_PARTS_WARRANTY
TOTAL_STANDARD_COST
VARIABLE_COST
VARIABLE_COST_CORP
VARIABLE_PROFIT
VARIABLE_PROFIT_CORP
VM_SALES_PROMOTION
VM_SALES_PROMOTION_CORP
W10_WARRANTY_PROFIT_ELIMINATION
W10_WARRANTY_PROFIT_ELIMINATION_CORP
WAREHOUSE_ALLOCATED_WARRANTY_ATCONSTANT
WARRANTY_DEALER
WARRANTY_REMANUFACTURE
WARRANTY_WAREHOUSE
WHOLESALE_DISCOUNTS
WINS_DEALER_TO_DEALER
WINS_FLEET
WINS_GOVERNMENT
WINS_GOVERNMENT_FLEET
WINS_WHOLESALE
X30_DAY_RETURNS
Labels (1)
Labels
Preview file
12 KB
680 Views
0 Likes
1 Reply
Vinicius_12
Partner - Contributor II
Partner - Contributor II
‎2022-01-24 10:38 AM

You can create on your filter the dimension with 'If', IF(not WildMatch(FieldName,'*_Corp'), FieldName)

637 Views
0 Likes