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

[WCS_OTTO]

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.

[MatheusC]

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('; ')

or

‘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

[WCS_OTTO]

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?

[MatheusC]

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

[WCS_OTTO]

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?

[MatheusC]

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

Login | Feedback

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