topic Re: Selection Trigger in QlikView in QlikView

Selection Trigger in QlikView

LucaStievano — Sat, 16 Nov 2024 16:41:06 GMT

Hi everyone,

I have 2 tables in qlikview:

products
components

products contains every product in the wharehouse, components is a linking table to show every products needed to manifacture a particular product.

i need, whenever i select a specific product to add to the same table(products) his components to the selection

is that even possible?

Thanks

Re: Selection Trigger in QlikView

Samuelthomas — Wed, 02 Aug 2023 04:57:52 GMT

@LucaStievano wrote:

Hi everyone,

I have 2 tables in qlikview:

products

components

products contains every product in the wharehouse, components is a linking table to show every products needed to manifacture a particular product. Hyundai USA Customer Service

i need, whenever i select a specific product to add to the same table(products) his components to the selection

is that even possible?

Thanks

Hello,

Yes, it is possible to achieve the desired behavior using a selection trigger in QlikView. You can use the OnSelect trigger on the product field in the products table to create a selection action. When a specific product is selected, the trigger can be programmed to add its components to the selection by using a select statement on the components field in the components table. This way, whenever a product is chosen, its associated components will be automatically selected as well, enriching the data in the products table.

Re: Selection Trigger in QlikView

marcus_sommer — Tue, 01 Aug 2023 14:12:11 GMT

If the products and the components are properly linked no selections of the components is needed because the selected products makes the associated components possible which would make them visible and calculable within the views.