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.