Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter of server data

How do we filter data in Qlik? For example, I have a table on the server with all invoices, but I only want to see a certain types of invoices? Can this be done in Qlik or does there need to be a view already created on the server?

1 Solution

Accepted Solutions
stabben23
Partner - Master
Partner - Master

Like this:

SQL SELECT *

FROM InvoiceTable

Where InvoiceType ='Paid'

;

View solution in original post

4 Replies
stabben23
Partner - Master
Partner - Master

Hi,

The easiest way is to use where statment in your sql query or whatever you use.

Not applicable
Author

Thanks Staffan. Where do I put this. With in the sheet? or before?

stabben23
Partner - Master
Partner - Master

Like this:

SQL SELECT *

FROM InvoiceTable

Where InvoiceType ='Paid'

;

maxgro
MVP
MVP

You can filter data when you load (in the script editor) the data from an external source, file, database, etc,..... For a database you can start from Staffan's suggestion.

OR

You can load all the data in Qlik and then filter in the user interface with QlikView objects.