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: 
kai_berlin
Contributor II
Contributor II

Filter not applied when clicking on combined dimension with table limitation

Hi,

I created a table where I combined two dimensions by using the following formula: "=item_number&'_'&item_name". In case I click on any row of this field two filters are applied automatically, one for item_number and one for item_name.

However in case I set a limitation for this field (since I only want so see the flop 3 rows for a specific measure) and I click again on the value of a row, nothing happens and no filter is applied.

Does anyone know if there is any workaround for this behaviour?

Best,
Kai

Qlik Sense Enterprise on Windows 

Labels (1)
1 Solution

Accepted Solutions
marksouzacosta

Hi @kai_berlin,

What @marcus_sommer is suggesting is, move your item_number&'_'&item_name formula to the Load Script and create a new field there, for example:

LOAD
item_number,
item_name,
item_number & '_' & item_name AS Item,
// Other fields ..
FROM
[YourSource]
;

 As a general rule, avoid Calculated Dimensions - like item_number&'_'&item_name. Move everything to the Load Script, as much as possible. This will make your UI easier to build and faster.

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

2 Replies
marcus_sommer

Don't do this within the UI else combine everything needed within the data-model to be able to use native fields in the UI.

marksouzacosta

Hi @kai_berlin,

What @marcus_sommer is suggesting is, move your item_number&'_'&item_name formula to the Load Script and create a new field there, for example:

LOAD
item_number,
item_name,
item_number & '_' & item_name AS Item,
// Other fields ..
FROM
[YourSource]
;

 As a general rule, avoid Calculated Dimensions - like item_number&'_'&item_name. Move everything to the Load Script, as much as possible. This will make your UI easier to build and faster.

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com