Preselect filter for datasheet

[PeterPiry]

Hi,

we have different divisions in our company, each division has different products. The products of different divisions have different characteristics.

So I have a table with all production, I want to have a sheet for each division.

How I can preselect the filter to the division for each datasheet? I can preselect in the table, but I want to do this for the whole sheet.

br

Peter

[MatheusC]

@PeterPiry 

Acredito que pode ser isso que você está procurando, crie um marcador que irá aplicar os filtros em todas as suas planilhas

1º Primeiro você cria o filtro que deseja.
2º vá para Criar novo marcador.
3º basta configurá-lo como padrão

Deixo também o link de ajuda do qlik para mais detalhes
https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Bookmarks/create-bookm...

[PeterPiry]

Hi,

thank you, but I'm searching more for a solution which is inside the code.

br

Peter Piry

[sidhiq91]

@PeterPiry  The best option would be to use bookmarks. But you can also try using Set Analysis where you can filter out only those particular divisions.

[PeterPiry]

Hi,

how can I use SetAnalysis on a filter?

br

Peter Piry

[MatheusC]

@PeterPiry 

I don't know if I understood correctly, I'll give an example of what I understood. If not, try to elaborate further with an example of the result you tend to achieve.

See if this is what you are looking for  :
SetAnalysis

Sum({<Dimension = {'Value_to_Filter'}>} measure)

[MatheusC]

@PeterPiry 

if you want to filter any value in the dimension, returning only a certain value from the field
There is also this example, removing nulls

=AGGR(only({<Dimension={'Value_to_Filter''}>}Dimension),Dimension)

[PeterPiry]

Hi,

thank you - I tried your formular, but his filters only the filter-field, not the whole datasheet ... ?

br

Peter Piry

[MatheusC]

@PeterPiry 

Do you want this in the data load editor?

If so, do it as follows

example1:

Load
field
-
-
-
from(qvd) where Campo='valor_filtro';

example2: // for more than one value to filter

Load
field
-
-
-
from(qvd) where WildMatch (field,'value1','value2');

[MatheusC]

@PeterPiry 

Did you manage to resolve this topic?

If you have finished, close the topic given the accepted solution.

Thanks!