Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Bart_Breekveldt
Contributor III
Contributor III

Two dimensions in one list

Good afternoon,

I want to filter values through a filter pane. However my values are in different tables. The dimensions contain different batch numbers for different product levels (an end product contains ingredients, which itself contains ingredients etc.).  If i would connect these batch numbers from different tables (the levels) in the script, it would cause circle references. If I add two dimensions in a filter pane, I get two lists side by side. I want however put these batch numbers in one list in a filter pane.

Is it possible to put two dimensions in one list in a filter pane in Qlik Sense?

Qlik one list Excel.PNG

Thanks in advance

 

Labels (3)
1 Reply
treysmithdev
Luminary Alumni
Luminary Alumni

I would look into building a LinkTable and creating a new field, [Batch Numbers], which includes both. A lot of times link tables are used to link 1 Dimension to 2+ Fact tables. However they are very useful in reverse: 1 Fact to 2+ Dimensions.

 

 

Blog: WhereClause   Twitter: @treysmithdev