topic Re: Export data/pdf/image together with the filter criteria applied in Data Movement & Streaming

Export data/pdf/image together with the filter criteria applied

WCS_OTTO — Wed, 19 Mar 2025 21:48:59 GMT

Hi, is it possible to show what filter criteria are being selected when exporting the data?

E.g. the data table includes Salesman (Name) and Sales Amount (value). The filter selected is Year = 2024. The export output only contains the two columns' info. As a reader, you don't know the figure is referring to 2024.

If exporting to data (excel), we can add it on our own. But if we export to pdf/image, we cannot add anything.

Re: Export data/pdf/image together with the filter criteria applied

MatheusC — Fri, 18 Oct 2024 12:59:29 GMT

Hi, @WCS_OTTO

You can opt for the following solution for your table chart, create an expression = ‘’ , setting its label to GetCurrentSelections like this example:

GetCurrentSelections('; ')

‘Selection: ’ & GetCurrentSelections('; ')

For the selection to be visible in your table, then in the “Show column if” tab, enter:

len(GetCurrentSelections())>0

So when you apply a filter, it will be applied to your table too.

- Matheus

Re: Export data/pdf/image together with the filter criteria applied

WCS_OTTO — Mon, 21 Oct 2024 01:33:39 GMT

Thanks Matheus, but I think you misunderstand my question.

Like this, I selected "MonthYear_ETD = 2022-01". When I export the content, I only got the columns' value (Customer Name, Seller, Seller Invoice Num, Currency, and Net Amt). But which period are these values referring to?

Is it possible to show the "MonthYear_ETD = 2022-01" in the export output?

Re: Export data/pdf/image together with the filter criteria applied

MatheusC — Mon, 21 Oct 2024 13:42:37 GMT

Maybe I didn't understand or it wasn't the expected solution, but look again at the solution given above and the printout of the output below:

- Regards, Matheus

Re: Export data/pdf/image together with the filter criteria applied

WCS_OTTO — Tue, 22 Oct 2024 08:10:44 GMT

Thanks, Matheus.

Now I understand what you mean. It's ok as an interim solution. But this is a bit difficult for us because we have a lot of apps, each app has quite a no. of sheets, and each sheet may contain more than one object. It will be a mass job to add this one by one.

Will there be a plan to have a feature/function for exporting the filter criteria together with the data?

Re: Export data/pdf/image together with the filter criteria applied

MatheusC — Tue, 22 Oct 2024 12:22:42 GMT

I'm happy that you managed to replicate the solution, it would be the solution I see at the moment. You can raise this idea to be voted on and follow to see if it will be implemented by qlik

It has the option of extension, although also if the biggest problem is replicating it in several applications it will also have this work and I don't know of any extension that can provide you with this information, but you can search for third party extensions, if applicable, and see if that gives you this expected result.

There are Vizlib extensions and Git itself, I don't like using these methods, but you can also check them.

- Regards