Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
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'