Filter not applied when clicking on combined dimension with table limitation

[kai_berlin]

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 

[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 · Accepted solution]

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