Two dimensions in one list

Bart_Breekveldt — Sat, 16 Nov 2024 04:19:21 GMT

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

Re: Two dimensions in one list

treysmithdev — Wed, 23 Oct 2019 02:21:42 GMT

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.

topic Re: Two dimensions in one list in App Development

Two dimensions in one list

Re: Two dimensions in one list