Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks in advance
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.