QlikFilter

[pjpkumar26]

Hello All,

I have a Qlik Sense Sheet and I want to filter only few departments and want only to show that depart always in the sheet filter

I can able to add filter but when i close the application and reopen the app the filter is gone 

how make that filter exist always in the sheet.

Many Thanks,

Kumar

[Kayde_72 · Accepted solution]

Try this out. The null may have one too many ) but should work out fine. This will get rid of any department that is not dept 1,2, and 3

=If(Match([Departments], 'Dept 1',), 'Dept 1',

If(Match([Departments], 'Dept 2',), 'Dept 2',

If(Match(Departments], 'Dept 3',), 'Dept 3',

Null()))))

Basically says if the department field matches the text 'dept 1', then label it 'dept 1'