Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
The easiest way is to use where statment in your sql query or whatever you use.
Thanks Staffan. Where do I put this. With in the sheet? or before?
Like this:
SQL SELECT *
FROM InvoiceTable
Where InvoiceType ='Paid'
;
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.