Auto selection in Filter Qliksense

[SureshbaabuAZ]

Hi Everyone,

I have a requirement in Qliksense to select a value in a filter based on a selection from another filter. ( Similar to 'select in field'  - field event triggers in Qlikview)

My table is designed as following. 

Requirement :

1. Defined value: If I choose 'Product 1' in Column 1, I wanted to reset the selection in Column 2 and have 'All' selected in 'Column 2'

2. Min String: If I choose 'Product 1' in Column 1, I wanted to reset the selection in Column 2 and have the min string selected 'Sub Product 1a' selected in 'Column 2'

Could you share your thoughts 

Column 1	Column 2	Column 3
Product 1	ALL	30
Product 1	Sub Product 1a	10
Product 1	Sub Product 1b	10
Product 1	Sub Product 1c	10
Product 2	ALL	60
Product 2	Sub Product 2a	20
Product 2	Sub Product 2b	10
Product 2	Sub Product 2c	30
All	All	90

Thank you.