Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Considering Drop down lists dynamically joining 2 tables

Dear Team,

I have one table (Table 1) - say "Department Master" - which has department and sub department names listed.

I have another table (Table 2) containing expenses and sub expenses (eg: Staff expenses - Personnel Expense & Training Expense) for each department + sub department combination.

Now I am showing a trendline of all these expenses over a period of the financial year.

I want 2 drop down lists (1 for department and 1 for sub-department). When I select a department, only then respective sub department drop down should get populated with values.

Also the trendline must display for the selected department (sub-department if selected or total of department if not selected).

Right now, when i created 2 drop down/selector in App OverView section. But all sub departments are getting displayed like a simple list. How to conditionally bring it in and how to use the synthetic key (department name) as a parameter for this?

Thanks & Regards,

Abhiram V

1 Reply
MVP & Luminary
MVP & Luminary

Re: Considering Drop down lists dynamically joining 2 tables

You can try using an expression like aggr([sub-department],[sub-department]) as dimension for the sub-department filter pane. That expression will make sure that only possible values are shown after a selection in the department field is made.

talk is cheap, supply exceeds demand