Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (2)
1 Reply
treysmithdev
Partner Ambassador
Partner Ambassador

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