Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

 

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

Not applicable
Author

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

sunny_talwar

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