Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

is it possible to filter a filter?

 

We are trying to limit display data in a column, it contains alpha, ~,   numbers we only want to see the alpha.
Or is there a way to stop it at the data load editor?
  We are doing a direct link to our database.

 

Tags (1)
1 Solution

Accepted Solutions

Re: is it possible to filter a filter?

Can you share the script you are using? I am having difficulty in understanding what you have right now.

On a similar note, you can restrict data from SQL either by restricting data directly in the SQL SELECT statement or you can do it in the preceding load statement. Read about preceding load here: Preceding Load

3 Replies

Re: is it possible to filter a filter?

Using Direct Discovery you mean or are you pulling data in memory through SQL?

Not applicable

Re: is it possible to filter a filter?

we linked up directly to the data base.

I use Microsoft excel and thru that I use SQL  can I use the SQL I create in Excel and connect?  That would filter for me.

I need the APP to refresh daily

Re: is it possible to filter a filter?

Can you share the script you are using? I am having difficulty in understanding what you have right now.

On a similar note, you can restrict data from SQL either by restricting data directly in the SQL SELECT statement or you can do it in the preceding load statement. Read about preceding load here: Preceding Load

Community Browser