topic Re: Dynamic filters for mapping in Compose for DW in Qlik Compose

Dynamic filters for mapping in Compose for DW

vtatarnikov — Fri, 14 Mar 2025 20:49:07 GMT

Hi there!

I am using
I want to pass a value to the mapping filter depending on the task.

For example, I am uploading data during the day for today and once a day for the last month. These are two different tasks in Compos, but the same mapping. I want to use different filters for the same mapping. Maintaining two mappings is not a good idea.

How best to do this, I did not find in the documentation.

Is it possible to create a variable on preloading and pass it to the filter? Is it possible to get the name of the task and, based on this, create a value in the filter? Now I see a variant based on the function of time, but I don't like it.

Thank you.

Re: Dynamic filters for mapping in Compose for DW

Nanda_Ravindra — Tue, 16 Aug 2022 20:35:03 GMT

@vtatarnikov I understand what you are asking, not sure if Compose supports that. I am checking with our internal team on this. So please stay tuned for an update on this.

Thanks,

Nanda

Re: Dynamic filters for mapping in Compose for DW

Nanda_Ravindra — Wed, 17 Aug 2022 14:24:07 GMT

@vtatarnikov Are you using full load only or do you use _ct as well?

We have some new features in 2022.5 where we can keep _ct table. For your use case, it looks like you can leverage this feature to reset the ct table and rerun the changes if you are using _ct.

What version of Compose are you running? Please review the below link for the new feature

https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Compose_Release_Notes/newfeatures.htm

Here are some slides on how the new feature works. Hope this helps!

Thanks,

Nanda

Re: Dynamic filters for mapping in Compose for DW

vtatarnikov — Thu, 18 Aug 2022 14:13:19 GMT

@Nanda_Ravindra thank you!

I don't use _ct tables. Your example doesn't look appropriate.

My use case looks like something simple and needed. It's strange that there is no such functionality. Could you create an Idea for implementation in future releases?

Re: Dynamic filters for mapping in Compose for DW

aj96 — Thu, 18 Aug 2022 17:20:00 GMT

I think you can create a table using the preloading ETL to load the time and use that table in the filter. That way I think you could use the same mapping but value can be changed based on the pre loading ETL.

Re: Dynamic filters for mapping in Compose for DW

vtatarnikov — Fri, 19 Aug 2022 12:58:26 GMT

thanks, but I can directly use the time function in the filter. I didn’t understand why create a table, and how you get a value from another table into a filter

Re: Dynamic filters for mapping in Compose for DW

Nanda_Ravindra — Mon, 22 Aug 2022 15:23:14 GMT

@vtatarnikov We don't support "run-time" variables currently. The other solution - to put a value in a table would be the way we would have to handle it today. If this is something you would like to try, you can open a support case and we can get a professional team to work with you.

Otherwise, please open a feature request on our community using this link. Unfortunately, I won't be able to open one for you on your behalf based on the feedback from the community.

https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight

Thanks,

Nanda