Skip to main content
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
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