Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stijnval
New Contributor III

Filter icon greyed out in Data Manager

Hi experts,

When loading local files in the Data Manager, we can see a filter icon, however it is constantly greyed out. Anybody knows how to get this button enabled?

Thanks in advance!

Stijn

1 Solution

Accepted Solutions
bwisealiahmad
Valued Contributor

Re: Filter icon greyed out in Data Manager

Hi,

You are using Excel file and you can't do that kind of filtering there (at least not yet).

If you can get the same data from a database you can do it there if you still want to use the Data Manger, otherwise I would add the Excel file through the Data Load Editor and use a "WHERE" clause on the load.

See picture from example where I've fetched data from a database and the icon is active:

FIlteringExample.PNG

2 Replies
bwisealiahmad
Valued Contributor

Re: Filter icon greyed out in Data Manager

Hi,

You are using Excel file and you can't do that kind of filtering there (at least not yet).

If you can get the same data from a database you can do it there if you still want to use the Data Manger, otherwise I would add the Excel file through the Data Load Editor and use a "WHERE" clause on the load.

See picture from example where I've fetched data from a database and the icon is active:

FIlteringExample.PNG

stijnval
New Contributor III

Re: Filter icon greyed out in Data Manager

Thanks Ali!

Community Browser